多项选择题

You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？（）

A. To recover a dropped table.
B. To recover a dropped schema.
C. To recover data from a truncated table.
D. To view changes made by all the transactions during a given period of time.
E. To view changes made by a single transaction during a given period of time.

点击查看答案&解析

上一题目录下一题

相关考题

多项选择题

In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command： CONFIGURE CONTROLFILE AUTOBACKUP ON； Which two events would cause the control file to be backed up automatically？（）

A. A tablespace is taken offline.
B. The database instance is restarted.
C. A new data file is added to an existing tablespace.
D. A successful backup is recorded in the RMAN repository.
E. The RMAN connection is disconnected from the target database.

单项选择题

You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）

A. Create a backup of the database and recover all corrupted blocks found in the backup.
B. Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.
C. Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.
D. Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.
E. Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.

单项选择题

What purpose would you achieve by enabling the block change tracking feature？（）

A. Eliminate the necessity for backups.
B. Perform optimized image copy backups.
C. Perform optimized incremental backups.
D. Enable checkpoint （CKPT） to perform checkpointing at every block change.
E. Enable database writer （DBWn） to write changed blocks to data files faster.

You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）

相关考题

You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？（）