You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）;  Which two statements are true？ （）

A

SYSDATE should not be used with TIMESTAMP.

B

The database must have multiplexed redo log files.

C

The database must be in the MOUNT state to execute the command.

D

The database must be opened with the RESETLOGS option after the flashback operation.

E

The entire database needs to be restored from the most recent backup before the flashback operation.

相关问题推荐

• You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）

  A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.

  B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.

  C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.

  D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.

  查看答案

• You are using the DBVERIFY utility to check the datafiles for any block corruption. You want to write the output of the dbv command to a file not to the screen.  Which parameter of the DBVERIFY utility will you use？（）

  A、 FILE

  B、 PARFILE

  C、 LOGFILE

  D、 FEEDBACK

  查看答案

• You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table， you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that：  a） No other user data in the database is affected.  b） The operation takes the minimum possible time.  Which option would you choose？（）

  A、 Use ROLLBACK command with SCN 663571.

  B、 Perform Flashback Transaction Query with SCN 663571.

  C、 Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.

  D、 Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571.

  查看答案

• You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）

  A、 The index tablespace contains bitmap indexes.

  B、 The index tablespace contains more than one data file.

  C、 The index tablespace supports only complete recovery.

  D、 The index tablespace is not a dictionary-managed tablespace.

  E、 There is a dependency relationship between a table and its indexes.

  查看答案

• In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries.  Which option would you use with the ALTER TABLE command to achieve this objective？（）

  A、REBUILD

  B、CASCADE

  C、TRUNCATE

  D、ROW MOVEMENT

  E、SHRINK SPACE COMPACT

  F、SHRINK SPACE CASCADE

  查看答案