You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below：  SGA_TARGET= 10GB  SGA_MAX_SIZE = 14GB  STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB  Which two statements are correct in this scenario？ （）

A . Information about each Oracle Net connection. B . Information about each entry in theLinstener.orafile C . Information about the changed done in the database D . Information about the different listeners in your system E . Information about all thenondatabasefiles required to operate the database

A . LOG_ARCHIVE_DEST B . LOG_ARCHIVE_START C . LOG_ARCHIVE_FORMAT D . LOG_ARCHIVE_MAX_PROCESSES

A .  Enable supplemental logging for the database. B .  Specify undo retention guarantee for the database C .  Create Flashback Data Archive in the tablespace where the tables are stored. D .  Create Flashback Data Archive and enable Flashback Data Archive for specific table

A . Extents would be managed by the freelists. B . The segment would be managed by bitmaps. C . The segment would be managed by the freelists. D . Free space would be managed by the data dictionary.

A . Set the UNDO_RETENTION parameter to AUTO. B . Create an initial undo segment in undotablespace. C . Set the UNDO_RETENTION parameter to 900 or more D . Set the initialization parameter UNDO_MANAGEMENT to AUTO E . Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

A .  log buffer B .  Java pool C .  Large pool D .  Fixed SGA E .  Shared pool F .  Streams pool G .  Keep buffer cache H .  Database buffer cache

A .  creating a table in your schema and you exceed your allocated space quota on the tablespace B .  executing a long query that involves a sort operation and the statement runs out of temporary space C .  loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit D .  creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

A .  set SHARED_POOL_SIZE to zero B .  set STATISTICS_LEVEL to BASIC C .  set SGA_TARGET to a non-zero value D .  set DB_CACHE_SIZE to a non-zero value E .  set STATISTICS_LEVEL to TYPICAL or ALL

A . block inheritance B . loopback processing C . security filtering D . WMI filtering

A .  the system change number B .  the locations of the redo log files C .  the locations of the datafiles D .  the physical location of all the database change

A . GET_RELATION_PROPERTY  B . SET_RELATION_PROPERTY  C . GET_BLOCK_PROPERTY  D . GET_FORM_PROPERTY

A . set SHARED_POOL_SIZE to zero B . set STATISTICS_LEVEL to BASIC C . set SGA_TARGET to a non-zero value D . set DB_CACHE_SIZE to a non-zero value E . set STATISTICS_LEVEL to TYPICAL or ALL

A .  Setting a nonzero value for SGA_TARGET B .  Configuring Automatic Shared Memory Management C .  Configuring Automatic Memory Management D .  Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET E .  None of the above

A . Publisher Activation page   B . Component Activation page   C . Cluster Setup page   D . Server Setup page&e

A . Information about each Oracle Net connection. B . Information about each entry in theLinstener.orafile C . Information about the changed done in the database D . Information about the different listeners in your system E . Information about all thenondatabasefiles required to operate the database

A . Enable the flash recovery area and specify it as the archived redo log destination. B . Disable the flash recovery area and start the database instance in ARCHIVELOG mode. C . Enable the flash recovery area but do not specify it as the archived redo log destination. D . Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.

A . SWITCH_TIME B . SWITCH_GROUP C . MAX_SESS_POOL D . SWITCH_ESTIMATE

A . SET AUTORECOVERY ON B . SET RECOVERY ON C . SET AUTO ON D . You cannot enable automatic media recovery.

A . Enable supplemental logging for the database. B . Specify undo retention guarantee for the database C . Create Flashback Data Archive in the tablespace where the tables are stored. D . Create Flashback Data Archive and enable Flashback Data Archive for specific table

A .  A total of 14 GB memory will be allocated to the automatically tuned memory components B .  Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB C .  The value for SGA_TARGET can be increased up to a maximum of 14 GB D .  A maximum of 3 GB can be allocated to shared pool E .  Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters F .  Increasing the value for SGA_TARGET will automatically increase the memory allocated for  STREAMS_POOL_SIZE

A .  Enable the flash recovery area and specify it as the archived redo log destination. B .  Disable the flash recovery area and start the database instance in ARCHIVELOG mode. C .  Enable the flash recovery area but do not specify it as the archived redo log destination.  D .  Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.

You are developing a Windows Communication Foundation (WCF) service. You enable logging in the configuration file.The opening tag is defined as follows.＜messagelogging br=&quot;&quot; logentiremessage=&quot;true&quot;＞ logMalformedMessages=&quot;true&quot;logMessagesAtServiceLevel=&quot;true&quot;logMessagesAtTransportLevel=&quot;true&quot;maxMessagesToLog=&quot;20&quot;＞You need to ensure that logging is implemented so that only messages with SOAP headers are logged.What should you add to the filters element of the application configuration file？（） A.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/dabf07576919d2888eaaebeeefbe8e42.jpg' /> B.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/0d3fc5a751c48bf4454f58321ef53f4c.jpg' /> C.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/c3e7538a5accad25aa4ac16ce8d2126d.jpg' /> D.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/241428daaa8185f55a085326b8cf7f39.jpg' />

You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command:You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT‘s segments.What would you do to achieve this？（） <img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/f856003f497492b5fcd1516f347bc3b8.jpg' /> A. Add a finding directive for the ADDM task. B. Add a segment directive for the ADDM task. C. Add a parameter directive for the ADDM task. D. Disable the Segment Advisor from the Automatic Maintenance Task.

You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.In which three ways can you re-create the lost disk group and restore the data？（） A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data. B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group. C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data. D. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data. E. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group. F. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.