单选题The database is configured for automatic archive logging. Along with the other required parameters， this entry is in the initialization file：log_archive_dest2="SERVICE=standby_db1 MANDATORY REOPEN=600" From where does the database resolve standby_db1？（

第1题：

Which statement is true regarding Dynamic Service Registration？（）

• A、Dynamic service registration requires configuration in the listener .ora file.
• B、Dynamic service registration can be used only with an Oracle9/instance.
• C、Dynamic service registration cannot register a local listener that does not use TCP/IP or port 1521.
• D、The PMON background process automatically registers each database instance if the necessary parameters have been set in the database initialization parameter file.

第2题：

Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service （IPS） to MetaLink？（）

• A、 The database must be running in ARCHIVELOG mode.
• B、 No special setup is required， and the feature is enabled by default.
• C、 The path for the Automatic Diagnostic Repository （ADR） must be configured with the  DIAGNOSTIC_DEST initialization parameter.
• D、 The Enterprise Manager Support Workbench can be enabled only if the background process manage ability monitor （MMON） is configured.
• E、 Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software， provide valid MetaLink credentials and select  license agreement.

第3题：

第4题：

The database is configured for automatic archive logging. Along with the other required parameters， this entry is in the initialization file：log_archive_dest2="SERVICE=standby_db1 MANDATORY REOPEN=600" From where does the database resolve standby_db1？（）

• A、control file
• B、tnsnames.ora
• C、data dictionary
• D、initialization parameter file

第5题：

In your database，the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory （OID）. SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command：$ SQLPLUS scott/tiger@DB01 AS SYSDBA   where DB01 is the net service name.   Which authentication method would be used first？（）  

• A、 authentication by password file
• B、 authentication by using certificates over SSL
• C、 authentication by using the Oracle Internet Directory
• D、 authentication by using the local OS of the database server

第6题：

You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance：   LOG_ARCHIVE_DEST 1 = ，，LOCATION=/disk1/arch MANDATORY’  LOG _ARCHIEVE_DEST 2 = ，，LOCATION=/disk2/arch’ LOG_ARCHIVK_DEST_3 = ，，LOCATION=/diSk3/arch  LOG_ARCH1VK_DEST_4 = ’ LOCATION=/disk4/arch’  LOG_ARCHIVE_MIN-SUCCEED_DEST = 2   While the database instance is functional，you realized that the destination set by the  LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.  What happens in an event of log switch？（）  

• A、 The online redo log file Is not allowed to be overwritten.
• B、 The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.
• C、 The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.
• D、 The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

第7题：

The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server：  LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc  LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’  DB_RECOVERY_FILE_DEST = ’/u01/oradata’  DB_RECOVERY_FILE_DEST_SIZE = 20G  Which statement is true regarding the archived redo log files（）

• A、It will be created on the local file system.
• B、It will be created only in the Flash Recovery Area.
• C、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.
• D、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.

第8题：

第9题：

You want to set the following initialization parameters for your database instance: LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch' LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch MANDATORY' Identify the statement that correctly describes this setting.（）

• A、The MANDATORY location must be a flash recovery area.
• B、The optional destinations may not use the flash recovery area.
• C、This setting is not allowed because the first destination is not set as MANDATORY.
• D、The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

第10题：

You want to set the following Initialization parameters for your database Instance   LOG_ARCHIVE_DEBT_1 = ，，LOCATION=/disk1/arch LOG_ARCHIVE_DBST_2 = ，，LOCATION=/disk2/arch LOC_ARCHIVB DBST_3 = ，，LOCATION=/disk3/arch LOG_ARCHIVE DBST_ = ，，LOCATION=/disk3/arch   Identify the statement that correctly describes this setting.（）  

• A、 The MANDATORY location must be a flash recovery area.
• B、 The optional destinations may not use the flash recovery area.
• C、 This setting is not allowed because the first destination is not set as MANDATORY.
• D、 The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.