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.

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.


相关考题:

AJSPpagecontainsataglibdirectivewhoseuriattributehasthevaluedbtags.WhichXMLelementwithinthewebapplicationdeploymentdescriptordefinestheassociatedTLD?() A.tlduridbtags/urilocation/WEB-INF/tlds/dbtags.tld/location/tldB.tagliburidbtags/urilocation/WEB-INF/tlds/dbtags.tld/location./taglibC.tld.tld-uridbtags/tld-uri.tld-location/WEB-INF/tlds/dbtags.tld/tld-location./tldD.taglibtaglib-uridbtags/taglib-uritaglib-location/WEB-INF/tlds/dbtags.tld./taglib-location./taglib

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.

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?()

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.

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=10gWherearethearchivedredologsstoredforyourdatabase?()

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.

Inyourdatabase,youmaybeforcedtoperformarecoveryusingtheRESETLOGSoptionduringwhichtheredologswouldberesettosequencenumber1.Youwanttoavoidtheoverwritingofoldlogfiles.Whicharchivedlogfilenameformatensuresthis?()A.%t_%s.dbfB.arch_%t.arcC.arch_%d.arcD.arch_%t_%d.arcE.arch_%d_%s_.dbfF.arch_%t_%s_%r.arc

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.

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.