niusouti.com

单选题Which of the following does the recover command not do？（）ARestore archived redo logs.BApply archived redo logs.CRestore incremental backups.DApply incremental backups.ERestore datafile images.

题目
单选题
Which of the following does the recover command not do？（）
A

 Restore archived redo logs.

B

 Apply archived redo logs.

C

 Restore incremental backups.

D

 Apply incremental backups.

E

 Restore datafile images.

相似考题

1.You issued the following RMAN command to back up the database:Which two statements are true regarding the backup performed?()A. Archived redo log files are backed up along with data files.B. Only data files are backed up and a restore point named FY06Q4 is created.C. Archived log files are backed up along with data files, and the archived log files are deleted.D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.

2.Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?（）1.Shut down the database.2.Take the users_01.dbf datafile offline with the alter database command.3.Restore the users_01.dbf datafile from backup media with the required archived redo logs.4.Restore all users tablespace-related datafiles from backup media.5.Issue the recover tablespace users command.6.Issue the recover datafile users_01.dbf command.7.Start up the database.8.Bring the users_01.dbf datafile online with the alter database command.A.1，3，6，7B.2，3，6，8C.1，2，3，6，7D.1，2，3，6，，7，8E.2，3，6，5，7

3.Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）A、SMON would automatically restore the lost file.B、You would need to restore the whole database from the last backup.C、You would need to restore the file from the last full database backup.D、You would need to use flashback technology to restore the lost redo log member.E、You would need to use Recovery Manager （RMAN） to restore the lost redo log member.F、You would need to restore the missing log file by copying one of the remaining files from the same group.

4.Which of the following files cannot be backed up by RMAN? ()(Choose all that apply.)A. Database datafilesB. Control filesC. Online redo logsD. Database pfilesE. Archived redo logs

更多“单选题Which of the following does the recover command not do？（）A  Restore archived redo logs.B  Apply archived redo logs.C  Restore incremental backups.D  Apply incremental backups.E  Restore datafile images.”相关问题

  • 第1题：

    You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）

    • A、Restore and recover the datafile. 
    • B、Restore and recover the tablespace. 
    • C、Restore and recover the database. 
    • D、Restore and recover the control file. 
    • E、Restore and recover the parameter file.

    正确答案:A

  • 第2题：

    Which command is used to begin a tablespace point-in-time recovery？（）  

    • A、 Restore tablespace
    • B、 Recover tablespace
    • C、 Tablespace recover
    • D、 Recover to time
    • E、 recover datafile

    正确答案:B

  • 第3题：

    Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（）  

    • A、 shutdown restore datafile 4； recover datafile 4； alter database open；
    • B、 Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；
    • C、 Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；
    • D、 Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；
    • E、 Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；

    正确答案:E

  • 第4题：

    Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.  To which point can you restore your database？（）  

    • A、 13：00 on Tuesday.
    • B、 15：00 on Tuesday.
    • C、 Up until the last available archived redo log on Sunday.
    • D、 To any point； all the redo should still be available in the online redo logs.
    • E、 The database is not recoverable.

    正确答案:E

  • 第5题：

    You lost the PRODSTD tablespace， which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace？（）

    • A、restore the tablespace from the backup; there is no need to apply the redo information 
    • B、restore the full database to recover the data up to the point when you performed the backup 
    • C、restore the tablespace from the backup， and then perform a recovery using the backup control file
    • D、restore the tablespace from the backup， and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied

    正确答案:D

  • 第6题：

    Which of the following files cannot be backed up by RMAN? （）(Choose all that apply.）

    • A、Database datafiles
    • B、Control files
    • C、Online redo logs
    • D、Database pfiles
    • E、Archived redo logs

    正确答案:C,D

  • 第7题：

    Your developers have asked you to restore the development database， which is in NOARCHIVELOG mode， back to last Tuesday the 20th. Your last backup is from Monday the 19th. What do you do？（）

    • A、 Restore the 19ths backup， restore all archived redo logs， recover the database to the 20th，and open the database.
    • B、 Tell them that their request cannot be met with the current backup strategy.
    • C、 Restore the 19ths backup， apply the online redo logs，and open the database.
    • D、 Switch the database into ARCHIVELOG mode，restore the 19th’s backup，restore all archived redo  logs，and recover the database to the 20th.
    • E、 Use the recover database command to roll back the database from today to the 19th of the month.

    正确答案:B

  • 第8题：

    单选题
    Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?（） 1.Shut down the database. 2.Take the users_01.dbf datafile offline with the alter database command. 3.Restore the users_01.dbf datafile from backup media with the required archived redo logs. 4.Restore all users tablespace-related datafiles from backup media. 5.Issue the recover tablespace users command. 6.Issue the recover datafile users_01.dbf command. 7.Start up the database. 8.Bring the users_01.dbf datafile online with the alter database command.
    A

    1，3，6，7

    B

    2，3，6，8

    C

    1，2，3，6，7

    D

    1，2，3，6，，7，8

    E

    2，3，6，5，7


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

  • 第9题：

    单选题
    Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（）
    A

     shutdown restore datafile 4； recover datafile 4； alter database open；

    B

     Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；

    C

     Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；

    D

     Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；

    E

     Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；


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

  • 第10题：

    单选题
    You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）
    A

     Restore and recover the datafile.

    B

     Restore and recover the tablespace.

    C

     Restore and recover the database.

    D

     Restore and recover the control file.

    E

     Restore and recover the parameter file.


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

  • 第11题：

    单选题
    You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）
    A

     restore the tablespace from the backup； there is no need to apply the redo information

    B

     restore the full database to recover the data up to the point when you performed the backup

    C

     restore the tablespace from the backup and then perform a recovery using the backup control file

    D

     restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied


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

  • 第12题：

    单选题
    You lost the PRODSTD tablespace， which was read-only. The tablespace was read-only when the last backup was taken. How would you recover the tablespace？（）
    A

     restore the tablespace from the backup， and then perform an incomplete recovery

    B

     restore the tablespace from the backup， and then apply all the redo information

    C

     restore all the data files in the database， and then perform an incomplete recovery

    D

     restore the tablespace from the backup


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

  • 第13题：

    You are trying to recover your database. During the recovery process， you receive the following error：   ORA-00279： change 5033391 generated at 08/17/2008 06：37：40 needed for thread 1ORA-00289： suggestion ：  /oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc  ORA-00280： change 5033391 for thread 1 is in sequence #11 ORA-00278： log  file ，，/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17  /o1_mf_1_10_4bj6wnqm_.arc no longer needed for this recovery Specify log： {=suggested | filename | AUTO | CANCEL} ORA-00308： cannot open archived log  ，，/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc  ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3   How do you respond to this error？（）

    • A、 Restore the archived redo log that is missing and attempt recovery again.
    • B、 Recovery is complete and you can open the database.
    • C、 Recovery needs redo that is not available in any archived redo log. Attempt to apply an online redo log if available.
    • D、 Recover the entire database and apply all archived redo logs again.
    • E、 Recovery is not possible because an archived redo log has been lost.

    正确答案:A,C

  • 第14题：

    Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?（） 1.Shut down the database. 2.Take the users_01.dbf datafile offline with the alter database command. 3.Restore the users_01.dbf datafile from backup media with the required archived redo logs. 4.Restore all users tablespace-related datafiles from backup media. 5.Issue the recover tablespace users command. 6.Issue the recover datafile users_01.dbf command. 7.Start up the database. 8.Bring the users_01.dbf datafile online with the alter database command.

    • A、1，3，6，7
    • B、2，3，6，8
    • C、1，2，3，6，7
    • D、1，2，3，6，，7，8
    • E、2，3，6，5，7

    正确答案:B

  • 第15题：

    What is the purpose of the recover command？（） 

    • A、 Recover database datafiles from physical disk backup sets.
    • B、 Recover required incremental backups from physical disk backup sets.
    • C、 Recover required archived redo logs from physical disk backup sets.
    • D、 Apply incremental backups to recover the database. 
    • E、 Apply archived redo logs to recover the database.

    正确答案:B,C,D,E

  • 第16题：

    Your database has experienced a loss of datafile users_01.dbf， which is associated with a ablespace called USERS.  The database is still running.  Which answer properly describes the rder of the steps that you would use to recover from this error？（）   a. Shut down the database.  b. Take the users_01.dbf datafile offline with the alter database command.  c. Restore the users_01.dbf datafile from backup media with the required archived redo logs.  d. Restore all users tablespace-related datafiles from backup media. e. Issue the recover tablespace users command. f. Issue the recover datafile users_01.dbf command. g. Start up the database.  h. Bring the users_01.dbf datafile online with the alter database command. 

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

    正确答案:B

  • 第17题：

    You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）

    • A、 restore the tablespace from the backup； there is no need to apply the redo information
    • B、 restore the full database to recover the data up to the point when you performed the backup
    • C、 restore the tablespace from the backup and then perform a recovery using the backup control file
    • D、 restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied

    正确答案:D

  • 第18题：

    Which of the following does the recover command not do？（）  

    • A、 Restore archived redo logs.
    • B、 Apply archived redo logs.
    • C、 Restore incremental backups.
    • D、 Apply incremental backups.
    • E、 Restore datafile images.

    正确答案:A

  • 第19题：

    单选题
    Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）
    A

    SMON would automatically restore the lost file.

    B

    You would need to restore the whole database from the last backup.

    C

    You would need to restore the file from the last full database backup.

    D

    You would need to use flashback technology to restore the lost redo log member.

    E

    You would need to use Recovery Manager （RMAN） to restore the lost redo log member.

    F

    You would need to restore the missing log file by copying one of the remaining files from the same group.


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

  • 第20题：

    单选题
    Your developers have asked you to restore the development database， which is in NOARCHIVELOG mode， back to last Tuesday the 20th. Your last backup is from Monday the 19th. What do you do？（）
    A

     Restore the 19ths backup， restore all archived redo logs， recover the database to the 20th，and open the database.

    B

     Tell them that their request cannot be met with the current backup strategy.

    C

     Restore the 19ths backup， apply the online redo logs，and open the database.

    D

     Switch the database into ARCHIVELOG mode，restore the 19th’s backup，restore all archived redo  logs，and recover the database to the 20th.

    E

     Use the recover database command to roll back the database from today to the 19th of the month.


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

  • 第21题：

    多选题
    What is the purpose of the recover command？（）
    A

    Recover database datafiles from physical disk backup sets.

    B

    Recover required incremental backups from physical disk backup sets.

    C

    Recover required archived redo logs from physical disk backup sets.

    D

    Apply incremental backups to recover the database.

    E

    Apply archived redo logs to recover the database.


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

  • 第22题：

    单选题
    Which of the following does the recover command not do？（）
    A

     Restore archived redo logs.

    B

     Apply archived redo logs.

    C

     Restore incremental backups.

    D

     Apply incremental backups.

    E

     Restore datafile images.


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

  • 第23题：

    单选题
    Which command is used to begin a tablespace point-in-time recovery？（）
    A

     Restore tablespace

    B

     Recover tablespace

    C

     Tablespace recover

    D

     Recover to time

    E

     recover datafile


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

  • 第24题：

    单选题
    Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.  To which point can you restore your database？（）
    A

     13：00 on Tuesday.

    B

     15：00 on Tuesday.

    C

     Up until the last available archived redo log on Sunday.

    D

     To any point； all the redo should still be available in the online redo logs.

    E

     The database is not recoverable.


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

相关内容