An error will occur during database startup because the second parameter is not valid.
An error will occur during database startup since you are trying to create archived redo logs in two different locations.
Archived redo logs will be created in two different locations by the ARCH process.
Archived redo logs will be created in two different locations by the LGWR process.
Neither parameter setting is valid, so the database will not start up.
第1题:
A.Anerrorwilloccurduringdatabasestartupbecausethesecondparameterisnotvalid.
B.Anerrorwilloccurduringdatabasestartupsinceyouaretryingtocreatearchivedredologsintwodifferentlocations.
C.ArchivedredologswillbecreatedintwodifferentlocationsbytheARCHprocess.
D.ArchivedredologswillbecreatedintwodifferentlocationsbytheLGWRprocess.
E.Neitherparametersettingisvalid,sothedatabasewillnotstartup.
第2题:
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.
第3题:
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.
第4题:
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?()
第5题:
What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant?()
第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?()
第7题:
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?()
第8题:
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.
第9题:
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()
第10题:
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()