单选题Which view provides information on the backup status of the datafiles in the database？（）AV$BACKUPBV$BACKUP_STATUSCV$BACKUP_DATAFILEDV$DATAFILE_BACKUPEV$TABLESPCE_BACKUP

第1题：

You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）

• A、 V$BACKUP_CORRUPTION
• B、 V$COPY_CORRUPTION
• C、 V$DATABASE_BLOCK_CORRUPTION
• D、 RC_BACKUP_CORRUPTION

第2题：

You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required？（）

• A、 V$DATABASE
• B、 V$FLASHBACK_DATABASE_STAT
• C、 V$FLASHBACK_DATABASE_LOG
• D、 V$RECOVERY_FILE_DEST

第3题：

Where can you obtain information about full database backup set created using RMAN， if the control file was used as the repository？（）

• A、V$BACKUPSET
• B、RC_DATABASE
• C、V$BACKUP_SET
• D、RC_BACKUP_SET

第4题：

You execute the following RMAN commands 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

第5题：

Which dynamic view displays the status of block-change tracking?（）

• A、V$BLOCK_CHANGE 
• B、V$BLOCK_CHANGE_TRACKING 
• C、V$BLOCKCHANGE 
• D、V$BLOCK_TRACKING

第6题：

Which dynamic performance view displays the information about the files associated with the locally managed temporary tablespaces in Oracle9i？（）

• A、V$DATAFILE
• B、V$TEMPFILE
• C、V$DBFILE
• D、V$DATAFILE_HEADER

第7题：

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.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）

• A、 V$FLASHBACK_DATABASE_LOG
• B、 V$FLASHBACK_DATABASE_STAT
• C、 V$DATABASE
• D、 V$UNDOSTAT

第14题：

Which view provides information on the backup status of the datafiles in the database？（）  

• A、 V$BACKUP
• B、 V$BACKUP_STATUS
• C、 V$BACKUP_DATAFILE
• D、 V$DATAFILE_BACKUP
• E、 V$TABLESPCE_BACKUP

第15题：

Which view provides information on the backup status of the datafiles in the database?（）

• A、V$BACKUP
• B、V$BACKUP_STATUS 
• C、V$BACKUP_DATAFILE 
• D、V$DATAFILE_BACKUP 
• E、V$TABLESPCE_BACKUP

第16题：

A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL> connect smith/smith  Connected.  SQL> SELECT * FROM v$session；  SELECT * FROM v$session *  ERROR at line 1：  ORA-00942： table or view does not exist  Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）

• A、granting SELECT privilege to SMITH on V$SESSION
• B、granting SELECT privilege to SMITH on V_$SESSION
• C、asking the user SMITH to run the catalog.sql script
• D、granting SELECT privilege to SMITH on V$FIXED_TABLES
• E、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
• F、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created

第17题：

You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）

• A、 Query the V$FLASHBACK_DATABASE_LOG view.
• B、 Query the V$FLASHBACK_DATABASE_STAT view.
• C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
• D、 Query the V$RECOVERY_FILE_DEST view.

第18题：

You executed the following code：   BACKUP VALIDATE DATABASE；   BLOCKRECOVER CORRUPTION LIST；  What will be the result of executing the above code？（）  

• A、 The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view.
• B、 The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.
• C、 The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.
• D、 The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.

第19题：

What view might you use to try to determine how long a particular backup will take？（）  

• A、 V$SESSION_EVENT
• B、 V$SESSION
• C、 V$WAITS
• D、 V$WAITSTAT
• E、 V$SESSION_LONGOPS

第20题：

第21题：

第22题：

第23题：