首页计算机考试Oracle认证
(单选题)

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.

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set.   How will you migrate your database from UTF8 to AL16UTF16?()  

    答案解析

  • (单选题)

    A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger,which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?()

    答案解析

  • (单选题)

    You want to perform in incomplete recovery of your database.  You plan to use these commands to recover your database:  SET UNTIL TIME = ’2000-12-09:11:44:00’;  RESTORE DATABASE; RECOVER DATABASE;  How should the commands be executed? ()

    答案解析

  • (单选题)

    You executed the following query in your database:  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output?()

    答案解析

  • (单选题)

    Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?()   a. restore controlfile  b. restore database  c. restore spfile  d. recover database  e. alter database open  f. alter database open resetlogs

    答案解析

  • (单选题)

    Given the following RMAN commands,choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.()   a. restore database  b. recover database  c. shutdown immediate  d. startup  e. restore archivelog all f. alter database open 

    答案解析

  • (多选题)

    You plan to execute the following command to perform a Flashback Database operation in your database:   SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);   Which two statements are true about this?()

    答案解析

  • (单选题)

    Your database runs in ARCHIVELOG mode, and is backed up every Sunday night using RMAN scripts. On Friday your database crashes. Now you want to use the backups from last Sunday night to restore your database.  How can you do this?()

    答案解析

  • (多选题)

    Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups.  Which two backups would you be able to perform when the database is being accessed by users?()

    答案解析

  • (单选题)

    You issued the following statement in your SQL*Plus session:   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600;   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database?()

    答案解析

快考试在线搜题