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？ （）

相似题目

• You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database.  What additional information is available to you when you enable tracing？（）

  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

  查看最佳答案

• Which initialization parameter must you set to enable automatic archiving？ （）

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

  查看最佳答案

• You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task？（）

  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

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）

  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

  查看最佳答案

• You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned？ （）

  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

  查看最佳答案

• You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）

  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

  查看最佳答案

• Which two initialization parameters would you set to enable Automatic Shared Memory Management？（）

  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

  查看最佳答案

• You need to recommend a solution for configuring the Automatic Updates settings on the VMs.   What should you include in the recommendation？（）

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

  查看最佳答案

• You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature.  What information will be written in the change tracking file？（）

  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

  查看最佳答案

• You need to allow the user to toggle between automatic query and no automatic query using a pop-up menu. Which built-in would you use in the menu item command to obtain the relationship name? （）

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

  查看最佳答案

• Which two initialization parameters would you set to enable Automatic Shared Memory Management?（）

  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

  查看最佳答案

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

  查看最佳答案

• You need to design a method to enable remote encryption on Server5. What should you do？（）

  A . Configure the editor’s user account properties to enable Store password using reversible encryption B . Configure the editor’s user account properties to enable Use DES encryption for this account C . Configure the Local Security Policy on Server to enable the System cryptography： Use FIPS compliant algorithms for encryption， hashing， and signing security policy D . Configure the Server5 computer account properties to enable Trust computer for delegatio

  查看最佳答案

• In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）  

  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

  查看最佳答案

• Where do you enable the CRS engine?（）

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

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）

  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

  查看最佳答案

• You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）

  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.

  查看最佳答案

• Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically， and to perform a switch to a low priority consumer group before they are initiated？（）

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

  查看最佳答案

• Which of the following would you use to enable automatic media recovery for a database？（）

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

  查看最佳答案

• You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What must you do accomplish this task?（）

  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

  查看最佳答案

• You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set？（）

  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

  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

  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 RMA

  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.

  查看最佳答案