Whatwillbetheresultofthefollowingconfiguration?()Log_archive_dest_1=location=c:\oracle\arch\mydbLog_archive_dest_2=location=z:\oracle\arch\mydbA.Anerrorwilloccurduringdatabasestartupbecausethesecondparameterisnotvalid.B.Anerrorwilloccurduringdatabasestart

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

相似考题

1.AJSPpagecontainsataglibdirectivewhoseuriattributehasthevaluedbtags.WhichXMLelementwithinthewebapplicationdeploymentdescriptordefinestheassociatedTLD?()A.<tld><uri>dbtags</uri><location>/WEB-INF/tlds/dbtags.tld</location></tld>B.<taglib><uri>dbtags</uri><location>/WEB-INF/tlds/dbtags.tld</location>.</taglib>C.<tld>.<tld-uri>dbtags</tld-uri>.<tld-location>/WEB-INF/tlds/dbtags.tld</tld-location>.</tld>D.<taglib><taglib-uri>dbtags</taglib-uri><taglib-location>/WEB-INF/tlds/dbtags.tld.</taglib-location>.</taglib>

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

3.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.

4.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.

更多“Whatwillbetheresultofthefollowingconfiguration?()Log_archive_dest_1=location=c:\oracle\arch\mydbLog_archive_dest_2=location=z:\oracle\arch\mydb ”相关问题

  • 第1题：

    YouareworkingasaDBAonOracleDatabase9i.Youplantoupgradeyour9idatabasetoOracle10g.Tobefamiliarwiththenewdatabasetechnology，youdecidetoinstallOracleDatabase10gonyourworkstationathome.Youcreateageneralpurposedatabase.

    Aftertheinstallation，youmakethefollowingchangesinyourinitializationparameterfile：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

    Wherearethearchivedredologsstoredforyourdatabase？（）


    参考答案：C

  • 第2题：

    Inyourdatabase，youmaybeforcedtoperformarecoveryusingtheRESETLOGSoptionduringwhichtheredologswouldberesettosequencenumber1.Youwanttoavoidtheoverwritingofoldlogfiles.Whicharchivedlogfilenameformatensuresthis？（）

    A.%t_%s.dbf

    B.arch_%t.arc

    C.arch_%d.arc

    D.arch_%t_%d.arc

    E.arch_%d_%s_.dbf

    F.arch_%t_%s_%r.arc


    参考答案：F

  • 第3题：

    You database is running an ARCHIVELOG mode.The following parameter are set in your database instance:LOG_ARCHIVE_FORMAT = arch+%t_%r.arcLOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’DB_RECOVERY_FILE_DEST_SIZE = 50GDB_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.


    参考答案：B

  • 第4题：

    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

  • 第5题：

    ThedatabaseisrunninginARCHIVELOGmode.Examinetheinitializationparametersandtheirvaluessettoenablearchivingonyourdatabaseserver：LOG_ARCHIVE_FORMAT=arch_%t_%s_%r.arcLOG_ARCHIVE_DEST_1=’LOCATION=/disk1/archive’DB_RECOVERY_FILE_DEST=’/u01/oradata’DB_RECOVERY_FILE_DEST_SIZE=20GWhichstatementistrueregardingthearchivedredologfiles（）

    A.Itwillbecreatedonthelocalfilesystem.

    B.ItwillbecreatedonlyintheFlashRecoveryArea.

    C.ItwillbecreatedinthelocationspecifiedbytheLOG_ARCHIVE_DEST_1parameterandthedefaultlocation$ORACLE_HOME/dbs.

    D.ItwillbecreatedinthelocationspecifiedbytheLOG_ARCHIVE_DEST_1parameterandlocationspecifiedbytheDB_RECOVERY_FILE_DESTparameter.


    参考答案：A

相关内容