Your database is configured in shared server mode. However， your senior DBA asks you to modify the value ofthe PRIVATE_SGA limit in the profile of the users.  What could be the reason for this（）

相似题目

• The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）

  A . statistics recommendations B . SQL Profile recommendations C . Index-related recommendations D . restructuring of SQL recommendatio

  查看最佳答案

• You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？ （）

  A . 3 hours B . 6 months C . until last year D . until last commit E . until the point when the undotablespacewas refreshed F . until the database is shut down and the memory erased

  查看最佳答案

• You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package. Which statement is true regarding the ACL created?（）

  A . It is a list of remote database links stored in the XML file that are available to the users of the database. B . It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts. C . It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts. D . It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.

  查看最佳答案

• Which options would you consider while configuring a flash recovery area fast recovery area in 11g Release 2 for your production database that is running in ARCHIVELOG mode？（） 

  A .  Setting the FAST_START_MTTR_TARGET to set the mean time to recover B .  Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs C .  Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area D .  Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

  查看最佳答案

• You are configuring a failover cluster for a database server. You are assigning four nodes to the cluster. Allnodes have access to a SAN，and adequate storage is available. Which of the following options should youchoose for your quorum configuration？（）

  A . Node Majority B . Node And Disk Majority C . Node And File Share Majority D . No Majority： Disk Only

  查看最佳答案

• In your database， UNDO_RETENTION has been set to 600 sec and UNDO tablespace is configured for RETENTION GUARANTEE. Which statement regarding RETENTION GUARANTEE is true？ （）

  A . Undo data is retained until the next full database backup. B . No committed undo data will be overwritten for 10 minutes. C . Committed undo data will be kept forever if not overwritten within 600 seconds. D . Guarantees that requested undo information are available until the instance is shut down.

  查看最佳答案

• ou need to configure fine-grained access control to external network resources from within your database. You create an access control list （ACL） using the DBMS_NETWORK_ACL_ADMIN package.  Which statement is true regarding the ACL created？（）

  A .  It is a list of remote database links stored in the XML file that are available to the users of the database. B .  It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts. C .  It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts. D .  It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.

  查看最佳答案

• The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?（）

  A . statistics recommendations B . SQL profile recommendations C . index-related recommendations D . restructuring of SQL recommendatio

  查看最佳答案

• You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files（）

  A . Archiving will be disabled because the destination for the redo log files is missing. B . The database instance will shut down and the error details will be logged in the alert log file. C . Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly. D . Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.

  查看最佳答案

• The size of the largest datafile， data1.dbf， in your database is 30MB. You issued the following command：   RMAN>CONFIGURE MAXSETSIZE 10MB；     What will be the impact of the above setting？（）

  A .  While performing the backup of the datafile，data1.dbf，one backup set is created. B .  While performing the backup of the datafile，data1.dbf，two backup sets are created. C .  While performing the backup of the datafile，data1.dbf，three backup sets are created. D .  While performing the backup of the datafile，data1.dbf，the command for performing a backup of the datafile，data1.dbf，will fail.

  查看最佳答案

• Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?（）

  A . Setting the FAST_START_MTTR_TARGET to set the mean time to recover B . Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs C . Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area D . Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

  查看最佳答案

• The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）

  A .  statistics recommendations B .  SQL profile recommendations C .  index-related recommendations D .  restructuring of SQL recommendatio

  查看最佳答案

• The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database：  RMAN> REPORT OBSOLETE;  What would you see in the output？（）

  A . a list of all the expired backups and copies B . a list of all those files that have been deleted in the last two days C . a list of all those files that have been recovered within the last two days D . a list of backups and copies that are outside the range covered by the current retention policy

  查看最佳答案

• Your database is configured in shared server mode. However， your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users.  What could be the reason for this（）

  A . to limit the User Global Area （UGA） memory allocated to a session from the SGA B . to limit the amount of memory to be used for the dispatcher queue of a session in SGA C . to limit the amount of memory to be used for the request pool in System Global Area （SGA） D . to control the amount of memory allocated in SGA for the local variables for each shared server proce

  查看最佳答案

• For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）  

  A .  Automatic PGA Memory Management B .  Automatic SGA Memory Management C .  Automatic Shared Memory Management D .  Automatic Memory Management E .  Manual SGA Memory Management F .  None of the above

  查看最佳答案

• You executed the following command in the lsnrctl utility to stop the listener： lsnrctl> STOP L1  What is the effect of this command if L1 is the only listener configured for your database？（）

  A . It terminates all user sessions. B . It prevents users from logging in to the database remotely. C . It halts the server until all user transactions are completed. D . The server hangs， so users will receive an error asking them to login again. E . Connected users would get an error with the message "End of communication channel".

  查看最佳答案

• You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? （）

  A . Clone  B . Copy  C . Template  D . Terminal&e

  查看最佳答案

• The SQL Tuning Advisor configuration has default settings in your database instance.  Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task？（）

  A .  statistics recommendations B .  SQL Profile recommendations C .  Index-related recommendations D .  restructuring of SQL recommendatio

  查看最佳答案

• Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage.  Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（） 

  A .  You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage. B .  You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage. C .  You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles. D .  You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.

  查看最佳答案

• 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 maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）

  A .  Increase the value of the FAST_START_MTTR_TARGET initialization parameter. B .  Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter. C .  Increase the value of the PGA_AGGREGATE_TARGET initialization parameter. D .  Increase the value of the SGA_TARGET initialization parameter.

  查看最佳答案

• The online redo log group configuration for your database is as follows： What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database？（） 

  A .  The database will hang. B .  The database will be crashed. C .  The database will be shut down. D .  The LGWR process writes redo log entries to the other redo log member of the Group2 grou

  查看最佳答案

• The SQL Tuning Advisor has been configured with default configurations in your database instance.Which recommendation is automatically implemented without the DBA‘s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）

  A. statistics recommendations B. SQL profile recommendations C. index-related recommendations D. restructuring of SQL recommendations

  查看最佳答案

• In your database, the flash recovery area （FRA) is configured as the default for RMAN back

  In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:Which statement is true about the outcome？（） <img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/4f3f38f4fa50f6813beecdb37f5e123f.jpg' /> A. Only one channel is allocated and the backup is created in the flash recovery area B. Only one channel is allocated and the backup is created in the destination specified for channel C. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2 D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

  查看最佳答案