网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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. ‘/ u01/app/oracle/oradata/orcl/users01.dbf
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
参考答案
更多 “ 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 copyB. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the last incremental backupC. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are updated with all changes up to incremental backup SCN. ‘/ u01/app/oracle/oradata/orcl/users01.dbfD. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are recovered using the above command if data file recovery fails ” 相关考题
考题
AuserexecutesaqueryontheEMPtable，whichcontainsthousandsofrows，togetdetailsaboutemployeesinoneofthedepartments.Theuserreceivesthefollowingerror：SQLSELECTenameFROMempWHEREdeptno=10ORDERBYsalSELECTenameFROMempWHEREdeptno=10ORDERBYsal*ERRORatline1：ORA01157：cannotidentify/lockdatafile201seeDBWRtracefileORA01110：datafile201：’/u01/app/oracle/oradata/orcl/temp01.dbf’Whatisapossiblereason？（）A.Thetempfilebelongingtothedefaulttemporarytablespaceismissing.B.Thedatabaseisopenedinrestrictedmode，soqueriesarenotallowed.C.Thedefaulttemporarytablespacerequiredtoexecutethequeryisoffline.D.Thedefaulttemporarytablespacerequiredtoexecutethequeryisdropped.E.Thedefaulttemporarytablespacerequiredtoexecutethequeryisreadonly.
考题
ExaminethecommandsexecutedinaDBAsession：SQLCREATEBIGFILETABLESPACEMRKT2DATAFILE’/u01/app/oracle/oradata/orcl/mrkt.dbf’size10MLOGGING3EXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTO；Tablespacecreated.SQLALTERDATABASEDEFAULTTABLESPACEMRKT；Databasealtered.WhichtwostatementsaretrueregardingtheMRKTtablespace（）A.Nomoredatafilescanbeaddedtothetablespace.B.Segmentspaceismanagedbyfreelistsinthetablespace.C.Ausercreatedwithoutbeingassignedadefaulttablespaceusesthistablespace.D.Thetablespacecanbedroppedwiththecurrentsettingwithsegmentspresentinit
考题
Youwanttocheckthedetailsoffewerrorsthatusershavereported.Yousearchforthealertlogfileandexecutefewcommandstofindthelocationofthealertlogfile.ViewtheExhibitandcheckthecommandsexecuted.Whatisthelocationofthealert_orcl.logfile（）A.ORACLE_HOME/dbsB.ORACLE_HOME/rdbmsC./u01/app/oracle/admin/orcl/adumpD./u01/app/oracle/flash_recovery_areaE.ORACLE_BASE/diag/rdbms/orcl/orcl/alertF.ORACLE_BASE/diag/rdbms/orcl/orcl/trace
考题
Examine the following values of the initialization parameters in the database having the SID ORCL:BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdumpUSER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udumpCORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdumpDIAGNOSTIC_DEST=The environment variables have the following value:ORACLE_BASE=/u01/app/oracleORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1What is the location of the Automatic Diagnostic Repository (ADR) home?（）A./u01/app/oracle/product/11.1.0/db_1B./u01/app/oracleC.$ORACLE_HOME/bdumpD.$ORACLE_HOME/log
考题
Whileworkingonthedatabase，youreceivethefollowingerror：01578：ORACLEdatablockcorrupted（file6，block54）ORA-01110：datafile6：’u01/oracle/oradata/data1.dbf’YoudecidetorecoverthecorrupteddatablockbyusingtheBlockMediaRecoveryfeature.WhichoptionisNOTadisadvantageofusingblockmediarecovery？（）A.BlockMediaRecoverymustbeusedwithRMAN.B.Youmustperformcompleterecoveryofindividualblocks.C.YoumusthaveafullRMANbackup，notanincrementalbackup.D.YoumustusetheDBVERIFYutilitybeforeusingtheBlockMediaRecoveryfeature.
考题
Youralertlogfilehasthefollowinginformation：TueMay2517：43：382004ORA-00060：Deadlockdetected.Moreinfoinfile/u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.Whatwouldyoudotoensurethatdatabaseisstillrunningcorrectly？（）A.examinethetracefileandkillthesessionthatcausedthedeadlockB.examinethetracefileandkillboththesessionsresponsibleforthedeadlockC.examinethetracefilefordetailsandasktheuserwhocausedthedeadlocktorollbackthetransactionD.examinethetracefilefordetailsandrememberthatdeadlocksareresolvedautomaticallybyOracledatabaseE.examinethetracefilefordetailsandusetheUndoAdvisortorollbackthetransactionthatcausedthedeadlock
考题
Youissuethefollowingstatement：SQLSELECTFIRSTNAME，LASTNAMEFROMHR.EMPLOYEE；Youreceivethefollowingerror：01578：ORACLEdatablockcorrupted（file6，block54）ORA-01110：datafile6：’u01/oracle/oradata/data1.dbf’Howwillyouresolvethisproblemofdatablockcorruptionbyreducingthemeantimetorecover（MTTR）？（）A.byusingtheDBMS_REPAIRpackageB.byusingtheDBVERIFYutilityC.byusingBlockMediaRecoveryD.byissuingtheANALYZETABLEHR.EMPLOYEESVALIDATESTRUCTUREcommand
考题
Youexecutedthefollowingcommand:RMANRECOVERCOPYOFDATAFILE’／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.
考题
YouworkasadatabaseadministratoratCertkiller&ensp
YouworkasadatabaseadministratoratCertkiller.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？（）
热门标签
最新试卷
