单选题What will be the result of the following configuration？（） Log_archive_dest_1=location=c：/oracle/arch/mydb Log_archive_dest_2=location=z：/oracle/arch/mydbA An error will occur during database startup because the second parameter is not valid.B An error will occur during database startup since you are trying to create archived redo logs in two different locations.C Archived redo logs will be created in two different locations by the ARCH process.D Archived redo logs will be created in two different locations by the LGWR process.E Neither parameter setting is valid， so the database will not start up.
单选题
What will be the result of the following configuration？（） Log_archive_dest_1=location=c：/oracle/arch/mydb Log_archive_dest_2=location=z：/oracle/arch/mydb
A
An error will occur during database startup because the second parameter is not valid.
B
An error will occur during database startup since you are trying to create archived redo logs in two different locations.
C
Archived redo logs will be created in two different locations by the ARCH process.
D
Archived redo logs will be created in two different locations by the LGWR process.
E
Neither parameter setting is valid， so the database will not start up.
参考解析
解析：
暂无解析
相关考题：
Youwanttosetthefollowinginitializationparametersforyourdatabaseinstance：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/archMANDATORY’Identifythestatementthatcorrectlydescribesthissetting.（）A.TheMANDATORYlocationmustbeaflashrecoveryarea.B.Theoptionaldestinationsmaynotusetheflashrecoveryarea.C.ThissettingisnotallowedbecausethefirstdestinationisnotsetasMANDATORY.D.Theonlineredologfileisnotallowedtobeoverwrittenifthearchivedlogcannotbecreatedinthefourthdestination.
You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?（）A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
Whatwillbetheresultofthefollowingconfiguration?()Log_archive_dest_1=location=c:\oracle\arch\mydbLog_archive_dest_2=location=z:\oracle\arch\mydb A.Anerrorwilloccurduringdatabasestartupbecausethesecondparameterisnotvalid.B.Anerrorwilloccurduringdatabasestartupsinceyouaretryingtocreatearchivedredologsintwodifferentlocations.C.ArchivedredologswillbecreatedintwodifferentlocationsbytheARCHprocess.D.ArchivedredologswillbecreatedintwodifferentlocationsbytheLGWRprocess.E.Neitherparametersettingisvalid，sothedatabasewillnotstartup.
YouhaveconfiguredflashrecoveryareainyourdatabaseandyousetthefollowingInitializationparametersforyourdatabaseinstance：LOG_ARCHIVE_DEST1=，，LOCATION=/disk1/archMANDATORY’LOG_ARCHIEVE_DEST2=，，LOCATION=/disk2/arch’LOG_ARCHIVK_DEST_3=，，LOCATION=/diSk3/archLOG_ARCH1VK_DEST_4=’LOCATION=/disk4/arch’LOG_ARCHIVE_MIN-SUCCEED_DEST=2Whilethedatabaseinstanceisfunctional，yourealizedthatthedestinationsetbytheLOG_ARCHIVE_DEST_IparameterIsnotavailableforthearchivedredologfiletobecreatedin.Allredologgroupshavebeenused.Whathappensinaneventoflogswitch？（）
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.
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.
What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture （OFA）-compliant？（）A、 ORACLE_BASE should be set explicitly.B、 An Oracle base should have only one Oracle home created in it.C、 Flash recovery area and data file location should be on separate disks.D、 Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management （ASM） setup.
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.
You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）A、The Oracle kernel will be placed in this location.B、The Oracle software will be placed in this location.C、The server parameter file （SPFILE） will be placed in this location.D、The database files will be placed in this location， if not specified explicitly.E、The location will be considered for the base of Oracle Managed Files （OMF）.F、The location will be considered for the base of Optimal Flexible Architecture （OFA）.
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.
You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradata’ Which statement is true about the archived redo log files?（）A、They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.B、They are created only in the Fast Recovery Area.C、They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.D、They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.
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.
Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）A、When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.B、When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.C、When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.D、When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database. After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’ DB_RECOVERY_FILE_DEST = ’LOCATION=d：/product/10.1.0/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g Where are the archived redo logs stored for your database？（）A、 The archived redo logs are stored in an operating system-dependent location.B、 The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.C、 The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.D、 The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and DB_RECOVERY_FILE_DEST.
You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications on the 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 FlashRecovery Area implicitly.D、Archiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.
单选题You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradata’ Which statement is true about the archived redo log files?（）AThey are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.BThey are created only in the Fast Recovery Area.CThey are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.DThey are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.
单选题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（）AArchiving will be disabled because the destination for the redo log files is missing.BThe database instance will shut down and the error details will be logged in the alert log file.CArchiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly.DArchiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.
单选题You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications on the archiving and the location of archive redo log files（）AArchiving will be disabled because the destination for the redo log files is missing.BThe database instance will shut down and the error details will be logged in the alert log file.CArchiving will be enabled and the destination for the archived redo log file will be set to the FlashRecovery Area implicitly.DArchiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.
单选题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.
单选题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（）AIt will be created on the local file system.BIt will be created only in the Flash Recovery Area.CIt will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.DIt will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.
单选题You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradata’ Which statement is true about the archived redo log files?（）AThey are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.BThey are created only in the Fast Recovery Area.CThey are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.DThey are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.
单选题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.
单选题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.（）AThe MANDATORY location must be a flash recovery area.BThe optional destinations may not use the flash recovery area.CThis setting is not allowed because the first destination is not set as MANDATORY.DThe online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.
单选题You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）AThe Oracle kernel will be placed in this location.BThe Oracle software will be placed in this location.CThe server parameter file （SPFILE） will be placed in this location.DThe database files will be placed in this location， if not specified explicitly.EThe location will be considered for the base of Oracle Managed Files （OMF）.FThe location will be considered for the base of Optimal Flexible Architecture （OFA）.
单选题You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database. After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’ DB_RECOVERY_FILE_DEST = ’LOCATION=d：/product/10.1.0/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g Where are the archived redo logs stored for your database？（）A The archived redo logs are stored in an operating system-dependent location.B The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.C The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.D The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and DB_RECOVERY_FILE_DEST.
单选题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.
单选题Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）AWhen you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.BWhen a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.CWhen a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.DWhen you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
单选题What will be the result of the following configuration？（） Log_archive_dest_1=location=c：/oracle/arch/mydb Log_archive_dest_2=location=z：/oracle/arch/mydbA An error will occur during database startup because the second parameter is not valid.B An error will occur during database startup since you are trying to create archived redo logs in two different locations.C Archived redo logs will be created in two different locations by the ARCH process.D Archived redo logs will be created in two different locations by the LGWR process.E Neither parameter setting is valid， so the database will not start up.