niusouti.com

单选题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 ima

题目
单选题
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

相似考题

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

2.ExaminethecommandsexecutedinaDBAsession：SQL>CREATEBIGFILETABLESPACEMRKT2DATAFILE’/u01/app/oracle/oradata/orcl/mrkt.dbf’size10MLOGGING3EXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTO；Tablespacecreated.SQL>ALTERDATABASEDEFAULTTABLESPACEMRKT；Databasealtered.WhichtwostatementsaretrueregardingtheMRKTtablespace（）A.Nomoredatafilescanbeaddedtothetablespace.B.Segmentspaceismanagedbyfreelistsinthetablespace.C.Ausercreatedwithoutbeingassignedadefaulttablespaceusesthistablespace.D.Thetablespacecanbedroppedwiththecurrentsettingwithsegmentspresentinit

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

4.AuserexecutesaqueryontheEMPtable，whichcontainsthousandsofrows，togetdetailsaboutemployeesinoneofthedepartments.Theuserreceivesthefollowingerror：SQL>SELECTenameFROMempWHEREdeptno=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.

参考答案和解析
正确答案： C
解析： 暂无解析
更多“单选题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 imag”相关问题

  • 第1题：

    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_1

    B./u01/app/oracle

    C.$ORACLE_HOME/bdump

    D.$ORACLE_HOME/log


    参考答案：B

  • 第2题：

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


    参考答案：D

  • 第3题：

    What does the output on this report indicate？（）   RMAN> report need backup；  RMAN retention policy will be applied to the command  RMAN retention policy is set to redundancy 1  Report of files with less than 1 redundant backups  File #bkps Name  5 0 C:///ORACLE/ORADATA/ORCL/MY_DATA_01.DBF  

    • A、 The my_data_01.dbf datafile is corrupted and needs to be restored.
    • B、 The my_data_01.dbf datafile has not yet been backed up. This report does not imply that the data in the datafile can not be recovered.
    • C、 The my_data_01.dbf datafile has not yet been backed up. This report implies that the data in the datafile can not be recovered.
    • D、 The my_data_01.dbf datafile no longer meets the retention criteria for backups.
    • E、 Datafile 5 is missing.

    正确答案:B

  • 第4题：

    A user sends you an email with the following error message： create table idtable（id number） * ERROR at line  1： ORA- 01110： data file 4： ，，/oracle01/oradata/orcl/users01.dbf ORA-27041： 01116： error in opening database file 4 ORA-unable to open file Linux Error：  2： No such file or directory Additional information：  3 You can choose from the following steps： a. Restore the missing database datafiles.  b. Take the missing datafile offline.  c. Shut down the database.  d. Issue the recover tablespace USERS command.  e. Issue the Startup Mount command to mount the database. f. Bring the USERS tablespace online.  g. Issue the alter database open command.  Which is the correct order of these steps in this case？（）

    • A、b， a， d， f
    • B、c， a， e， b， d， f， g
    • C、c， e， d， g
    • D、b， d， f 
    • E、e， d， g

    正确答案:A

  • 第5题：

    What is the impact of the results of the output of the following command？（）   RMAN> report unrecoverable database；  Report of files that need backup due to unrecoverable operations  File Type of Backup Required Name  4 full or incremental C:///ORACLE/ORADATA/ORCL/USERS01.DBF  

    • A、 There are no backup sets with any backups of the users01.dbf datafile.
    • B、 The users01.dbf datafile has had unrecoverable operations occur in it. It will need to be backed up or some data loss is possible during a recovery.
    • C、 The users01.dbf datafile is corrupted.
    • D、 The users01.dbf datafile backup exceeds the retention criteria.
    • E、 The last backup of the users01.dbf datafile failed and must be rerun.

    正确答案:D

  • 第6题：

    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

    正确答案:C

  • 第7题：

    You issue the following statement：   SQL> SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE；  You receive the following error：         01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）

    • A、 by using the DBMS_REPAIR package
    • B、 by using the DBVERIFY utility
    • C、 by using Block Media Recovery
    • D、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command

    正确答案:C

  • 第8题：

    单选题
    You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51）  ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following：  The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file and all the archived logs are accessible.  Which option would you choose？（）
    A

     flash back the corrupted blocks

    B

     use the DBMS_REPAIR package

    C

     use the RMAN TSPITR command

    D

     use the RMAN BLOCKRECOVER command

    E

     use the RESTORE DATABASE and RECOVER DATABASE commands

    F

     investigate the time at which the corruption occurred and perform a point-in-time recovery


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    A user sends you an email with the following error message： create table idtable（id number） * ERROR at line  1： ORA- 01110： data file 4： ，，/oracle01/oradata/orcl/users01.dbf ORA-27041： 01116： error in opening database file 4 ORA-unable to open file Linux Error：  2： No such file or directory Additional information：  3 You can choose from the following steps： a. Restore the missing database datafiles.  b. Take the missing datafile offline.  c. Shut down the database.  d. Issue the recover tablespace USERS command.  e. Issue the Startup Mount command to mount the database. f. Bring the USERS tablespace online.  g. Issue the alter database open command.  Which is the correct order of these steps in this case？（）
    A

    b， a， d， f

    B

    c， a， e， b， d， f， g

    C

    c， e， d， g

    D

    b， d， f 

    E

    e， d， g


    正确答案： E
    解析： 暂无解析

  • 第10题：

    单选题
    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/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST=   The environment variables have the following value：   ORACLE_BASE=/u01/app/oracle  ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1   What is the location of the Automatic Diagnostic Repository （ADR） home？（）
    A

     /u01/app/oracle/product/11.1.0/db_1

    B

     /u01/app/oracle

    C

     $ORACLE_HOME/bdump

    D

     $ORACLE_HOME/log


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    What is the impact of the results of the output of the following command？（）   RMAN> report unrecoverable database；  Report of files that need backup due to unrecoverable operations  File Type of Backup Required Name  4 full or incremental C:///ORACLE/ORADATA/ORCL/USERS01.DBF
    A

     There are no backup sets with any backups of the users01.dbf datafile.

    B

     The users01.dbf datafile has had unrecoverable operations occur in it. It will need to be backed up or some data loss is possible during a recovery.

    C

     The users01.dbf datafile is corrupted.

    D

     The users01.dbf datafile backup exceeds the retention criteria.

    E

     The last backup of the users01.dbf datafile failed and must be rerun.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    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/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What is the location of the Automatic Diagnostic Repository (ADR) home?（）
    A

    /u01/app/oracle/product/11.1.0/db_1

    B

    /u01/app/oracle

    C

    $ORACLE_HOME/bdump

    D

    $ORACLE_HOME/log


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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.


    参考答案：C

  • 第14题：

    While working on the database， you receive the following error：        01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）

    • A、 Block Media Recovery must be used with RMAN.
    • B、 You must perform complete recovery of individual blocks.
    • C、 You must have a full RMAN backup， not an incremental backup.
    • D、 You must use the DBVERIFY utility before using the Block Media Recovery feature.

    正确答案:D

  • 第15题：

    Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5：  ’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following： The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file， and all the archived logs are accessible.   Which option would you choose？（）

    • A、flash back the corrupted blocks
    • B、use the DBMS_REPAIR package
    • C、use the RMAN TSPITR command
    • D、use the RMAN BLOCKRECOVER command
    • E、use the RESTORE DATABASE and RECOVER DATABASE commands
    • F、investigate the time at which the corruption occurred and perform a point-in-time recovery

    正确答案:D

  • 第16题：

    You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51）  ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following：  The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file and all the archived logs are accessible.  Which option would you choose？（）

    • A、 flash back the corrupted blocks
    • B、 use the DBMS_REPAIR package
    • C、 use the RMAN TSPITR command
    • D、 use the RMAN BLOCKRECOVER command
    • E、 use the RESTORE DATABASE and RECOVER DATABASE commands
    • F、 investigate the time at which the corruption occurred and perform a point-in-time recovery

    正确答案:D

  • 第17题：

    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.

    正确答案:C

  • 第18题：

    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/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What is the location of the Automatic Diagnostic Repository (ADR) home?（）

    • A、/u01/app/oracle/product/11.1.0/db_1
    • B、/u01/app/oracle
    • C、$ORACLE_HOME/bdump
    • D、$ORACLE_HOME/log

    正确答案:B

  • 第19题：

    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/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST=   The environment variables have the following value：   ORACLE_BASE=/u01/app/oracle  ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1   What is the location of the Automatic Diagnostic Repository （ADR） home？（）

    • A、 /u01/app/oracle/product/11.1.0/db_1
    • B、 /u01/app/oracle
    • C、 $ORACLE_HOME/bdump
    • D、 $ORACLE_HOME/log

    正确答案:B

  • 第20题：

    单选题
    You issue the following statement：   SQL> SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE；  You receive the following error：         01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）
    A

     by using the DBMS_REPAIR package

    B

     by using the DBVERIFY utility

    C

     by using Block Media Recovery

    D

     by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51） ORA/x7f01110： data file 5： ’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following： The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file， and all the archived logs are accessible. Which option would you choose？（）
    A

    flash back the corrupted blocks

    B

    use the DBMS_REPAIR package

    C

    use the RMAN TSPITR command

    D

    use the RMAN BLOCKRECOVER command

    E

    use the RESTORE DATABASE and RECOVER DATABASE commands

    F

    investigate the time at which the corruption occurred and perform a point­in­time recovery


    正确答案： F
    解析： 暂无解析

  • 第22题：

    单选题
    While working on the database， you receive the following error：        01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）
    A

     Block Media Recovery must be used with RMAN.

    B

     You must perform complete recovery of individual blocks.

    C

     You must have a full RMAN backup， not an incremental backup.

    D

     You must use the DBVERIFY utility before using the Block Media Recovery feature.


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

相关内容