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.

  查看答案

• 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 observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： % rman target / What would be the effect of this command？（）

  A、 RMAN would use the current operating system location to place the backup.

  B、 RMAN would use the control file of the target database to maintain the backup.

  C、 RMAN would use the recovery catalog of the target database to maintain the backup.

  D、 RMAN would use the control file of the target database to maintain the backup metadata.

  E、 RMAN would use the recovery catalog of the target database to maintain the backup metadata.

  查看答案

• 与语句cout＜＜endl；不等价的是()。

  A．cout＜＜‘’；

  B．cout＜＜‘12’；

  C．cout＜＜‘xA’；

  D．cout＜＜‘’；

  查看答案

• Which view will you use to view information regarding the jobs that are currently running in a database？（）

  A、DBA_SCHEDULER_RUNNING_JOBS

  B、DBA_SCHEDULER_JOB_RUN_DETAILS

  C、DBA_SCHEDULER_JOBS

  D、DBA_SCHEDULER_JOB_LOG

  查看答案