The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）

A、 time-based recovery

B、 log sequence recovery

C、 cancel-based recovery

D、 change-based recovery

相关问题推荐

• You issued the following command：        SQL> DROP TABLE MYTABLE；        SQL> SHOW RECYCLEBIN  The following output is returned：        ORIGINAL NAME RECYCLEBIN NAME               OBJECT TYPE      DROP TIME        ------------- ------------------------------ --------------- --------------------        MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0     TABLE           2005-01-13：20：11：31  You want to drop the table， MYTABLE， from the Recycle Bin. Which two commands can you issue to accomplish the desired task？（）

  A

   DROP TABLE MYTABLE PURGE；

  B

   PURGE RECYCLEBIN；

  C

   PURGE TABLE MYTABLE；

  D

   PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0；

  查看答案

• You are using Oracle Database 10g. You performed an  incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？（）

  A

  This operation resets the SCN for the database.

  B

  This operation creates a new incarnation of the database.

  C

  This operation moves all the redo log files to a different location.

  D

  This operation deletes the old redo log files and creates new redo log files.

  E

  This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

  查看答案

• Which statement correctly describes the change tracking writer （CTWR） background process？（）

  A、 It keeps track of changes in the background processes.

  B、 It records the system change number （SCN） in the control file.

  C、 It writes audit records for user changes to the change tracking file.

  D、 It records any changes to the listened configuration in the listener.ora file.

  E、 It records any changes to the database parameters in the change tracking file.

  F、 It records the physical location of all the changes that are made to the database in the change tracking file.

  查看答案

• In which scenario will you create a sorted hash cluster？ （）

  A、 if the application uses queries joining tables only occasionally

  B、 if the full table scan is executed often on only one table of the clustered tables

  C、 if the data for all the rows of a cluster key value exceeds one or two Oracle blocks

  D、 when you want the data to be returned automatically in the chronological order

  查看答案

• Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）： CREATE TABLESPACE user_tbsp DATAFILE ’+dgroup3 （usder_temp） /user_files/user_tbsp’ SIZE 200M； What would be the result of this command？（）

  A、 It would result in an error because the template cannot be used along with the disk group.

  B、 It would result in an error because the path cannot be specified while creating a tablespace in a disk group.

  C、 It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.

  D、 It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.

  查看答案