违法和不良信息举报 联系客服
免费注册 登录

单选题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=/disk

题目
单选题
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.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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.


参考答案：C

第2题：

YouwanttosetthefollowingInitializationparametersforyourdatabaseInstanceLOG_ARCHIVE_DEBT_1=，，LOCATION=/disk1/archLOG_ARCHIVE_DBST_2=，，LOCATION=/disk2/archLOC_ARCHIVBDBST_3=，，LOCATION=/disk3/archLOG_ARCHIVEDBST_=，，LOCATION=/disk3/archIdentifythestatementthatcorrectlydescribesthissetting.（）

A.TheMANDATORYlocationmustbeaflashrecoveryarea.

B.Theoptionaldestinationsmaynotusetheflashrecoveryarea.

C.ThissettingisnotallowedbecausethefirstdestinationisnotsetasMANDATORY.

D.Theonlineredologfileisnotallowedtobeoverwrittenifthearchivedlogcannotbecreatedinthefourthdestination.


参考答案：D

第3题：

You want to set the following initialization parameters for your database instance: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.


参考答案：D

第4题：

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.

正确答案:A

第5题：

Examine the RMAN command： SWITCH DATAFILE ’/DISK3/user_data01.dbf’； Which command do you need to issue before you issue the above command， so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’？ （）

  • A、RESTORE DATAFILE ’/DISK2/user_data01.dbf’
  • B、RESTORE DATAFILE ’/DISK3/user_data01.dbf’
  • C、SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’
  • D、SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’

正确答案:C

第6题：

YouhaveconfiguredflashrecoveryareainyourdatabaseandyousetthefollowingInitializationparametersforyourdatabaseinstance：

LOG_ARCHIVE_DEST1=，，LOCATION=/disk1/archMANDATORY’

LOG_ARCHIEVE_DEST2=，，LOCATION=/disk2/arch’

LOG_ARCHIVK_DEST_3=，，LOCATION=/diSk3/arch

LOG_ARCH1VK_DEST_4=’LOCATION=/disk4/arch’

LOG_ARCHIVE_MIN-SUCCEED_DEST=2

Whilethedatabaseinstanceisfunctional，yourealizedthatthedestinationsetbythe

LOG_ARCHIVE_DEST_IparameterIsnotavailableforthearchivedredologfiletobecreatedin.Allredologgroupshavebeenused.

Whathappensinaneventoflogswitch？（）


参考答案：D

第7题：

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.


参考答案：D

第8题：

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.


参考答案：D

第9题：

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.

正确答案:D

第10题：

You decided to change the location of the flash recovery area. You executed the following command：   ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’；   Which statement is true？（）

  • A、 The location can be changed only if the flash recovery area is empty.
  • B、 After executing the command， all new flash recovery area files will be created in the new location.
  • C、 The command will generate an error because you cannot change the flash recovery area while the database is open.
  • D、 All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.

正确答案:B

更多相关问题
相关内容