单选题William specified the following initialization parameter settings in the pfile： BACKGROUND_DUMP_DEST = ’u01/oradata/dir_A’ USER_DUMP_DEST = ’u01/oradata/dir_B’ DB_CREATE_FILE_DEST = ’u01/oradata/dir_C’ DB_CREATE_ONLINE_LOG_DEST_n = ’u01/oradata

题目

单选题

William specified the following initialization parameter settings in the pfile： BACKGROUND_DUMP_DEST = ’u01/oradata/dir_A’ USER_DUMP_DEST = ’u01/oradata/dir_B’ DB_CREATE_FILE_DEST = ’u01/oradata/dir_C’ DB_CREATE_ONLINE_LOG_DEST_n = ’u01/oradata/dir_D’ William enabled the change-tracking feature because he does not want to scan the entire datafile during backup. What is the default storage location for the change tracking file？（）

’u01/oradata/dir_A’

’u01/oradata/dir_B’

’u01/oradata/dir_C’

’u01/oradata/dir_D’

参考答案和解析

正确答案： C

解析：暂无解析

更多“单选题William specified the following initialization parameter settings in the pfile： BACKGROUND_DUMP_DEST = ’u01/oradata/dir_A’ USER_DUMP_DEST = ’u01/oradata/dir_B’ DB_CREATE_FILE_DEST = ’u01/oradata/dir_C’ DB_CREATE_ONLINE_LOG_DEST_n = ’u01/oradata”相关问题

第1题

Youexecutedthefollowingcommand:RMAN>RECOVERCOPYOFDATAFILE’／u01／app／oracle／oradata／orcl／users01.dbf’;Whichstatementregardingtheabovecommandiscorrect?()A.The’/u01/app/oracle/oradata/orcl/users01.dbf’datafileisrecoveredfromtheimagecopy.B.The’/u01/app/oracle/oradata/orcl/users01.dbf’datafileisrecoveredfromthelastincrementalbackup.C.Imagecopiesofthe’/u01/app/oracle/oradata/orcl/users01.dbf’datafileareupdatedwithallchangesuptoincrementalbackupSCN.D.Imagecopiesofthe’/u01/app/oracle/oradata/orcl/users01.dbf’datafilearerecoveredusingtheabovecommandifdatafilerecoveryfails.

点击查看答案
第2题

YouworkasadatabaseadministratoratCertkiller&enspYouworkasadatabaseadministratoratCertkiller.com.YourdatabaseisopenandrunninginARCHIVELOGmode.YoutakeRMANfullbackupseverySundaynight.OnMondaymorning，whilequeryingtheuser1.employeestable，youreceivethefollowingerrormessage：01578：ORACLEdatablockcorrupted（file#5，block#51）ORA-01110：datafile5：’/u01/app/oracle/oradata/orcl/example01.dbf’Youneedtorectifythecorruptionwhileensuringthefollowing：Thedatafileshouldremainonline.Themeantimetorecover（MTTR）shouldbeminimal.Youarenotusingabackupcontrolfileandallthearchivedlogsareaccessible.Whichoptionwouldyouchoose？（）

点击查看答案
第3题

Examinethefollowingparametersettingsfromaninitialization（init.ora）file：DB_CREATE_FILE_DEST=’/u01/oradata/’DB_CREATE_ONLINE_LOG_DEST_1=’/u02/oradata/’DB_CREATE_ONLINE_LOG_DEST_2=’/u03/oradata/’IfyoucreateanOracleManagedFiles（OMF）databaseusingthesesettings，whatistheresult？（）A.AB.BC.CD.D

点击查看答案
第4题

YouissuethefollowingcommandinOracle:CREATETABLESPACEDAT_TBSDATAFILE"dat_tbs.dbf"SIZE2M;.Laterqueriesagainstthedatabaserevealthatthetablespaceislocatedinthe/u01/oradata/oracledirectory.WhichofthefollowingchoicesidentifieshowOraclelikelydeterminedwhatdirectorytoplacedat_tbs.dbffilein?（）A.DB_CREATE_FILE_DESTB.DB_CREATE_ONLINE_LOG_1C.DB_CREATE_ONLINE_LOG_2D.Thedirectoryisanoperatingsystem-specificdefaultvalueinOraclethatcanneigherbespecifiedmanuallynorchanged

点击查看答案
第5题

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.

点击查看答案
第6题

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.

点击查看答案
第7题

You executed the following command： RMAN> RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’； Which statement regarding the above command is correct？（） A、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy.B、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup.C、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.D、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.

点击查看答案

单选题William specified the following initialization parameter settings in the pfile： BACKGROUND_DUMP_DEST = ’u01/oradata/dir_A’ USER_DUMP_DEST = ’u01/oradata/dir_B’ DB_CREATE_FILE_DEST = ’u01/oradata/dir_C’ DB_CREATE_ONLINE_LOG_DEST_n = ’u01/oradata

题目

参考答案和解析

更多“单选题William specified the following initialization parameter settings in the pfile： BACKGROUND_DUMP_DEST = ’u01/oradata/dir_A’ USER_DUMP_DEST = ’u01/oradata/dir_B’ DB_CREATE_FILE_DEST = ’u01/oradata/dir_C’ DB_CREATE_ONLINE_LOG_DEST_n = ’u01/oradata”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容