单选题Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation？（）A V$COPY_CORRUPTB V$COPY_CORRUPTIONC V$BACKUP_CORRUPTD V$BACKUP_CORRUPTION

第1题：

You execute the following Recovery Manager （RMAN） commands in he following order：   BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST；   Which two tasks are performed by these commands？（）  

• A、 Repair the corrupted blocks. If any. In the backup created
• B、 Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks
• C、 Back up the database after checking whether array of the files have corrupted blocks
• D、 Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION view
• E、 Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION

第2题：

On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）

• A、Check the alert log file
• B、Query the V$FLASHBACK_DATABASE_LOG view
• C、Query the V$RECOVERY_FILE_DEST_SIZE view
• D、Query the V$FLASHBACK_DATABASE_STAT view
• E、Check the value assigned for the UNDO_RETENTION parameter

第3题：

Which of the following are correct about block media recovery？（）

• A、 Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTION
• B、 Logical corruptions are repairable by BMR
• C、 Physical corruptions are repairable by BMR
• D、 RMAN can use any backup for a BMR restore
• E、 ARCHIVELOG mode is not required if you have both a full and incremental backup for restore

第4题：

Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation？（）

• A、V$COPY_CORRUPT
• B、V$COPY_CORRUPTION
• C、V$BACKUP_CORRUPT
• D、V$BACKUP_CORRUPTION

第5题：

You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file， if it has already been backed up.（）

• A、 The data file backup is done with multiple channels
• B、 The data files is in the read-write mode after being backed up in the read only mode
• C、 The backup was taken after the data files was taken offline-normal or is in the read only mode
• D、 The data file backup complies with the back retention policy and the backup duplexing fe ture

第6题：

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.

第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题：

You are creating a Web Form. The Web Form allows users to rename or delete products in a list. You create a DataTable named dtProducts that is bound to a GridView. DataTable has the following four rows. dtProducts. Rows[0]["ProductName"] = “Soap”;dtProducts. Rows[1][“ProductName”]= “Book”;dtProducts. Rows[2][“ProductName”]= “Computer”;dtProducts. Rows[3][“ProductName”]= “Spoon”;dtProducts. AcceptChanges（　）; The user utilizes a Web Form to delete the first product. You need to set the RowStateFilter property of the DataTables DefaultView so that only products that have not been deleted are shown. To which value should you set the DataTabless DefaultView.RowStateFilter? （）

• A、Data V iewRowState.ModifiedOriginal;
• B、Data V iewRowState.ModifiedCurrent;
• C、Data V iewRowState.CurrentRows;
• D、Data V iewRowState.Added;

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）

• A、Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.
• B、Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
• C、Data is never redacted for the EMP_V.SAL column.
• D、Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
• E、Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

第15题：

Which data dictionary views displays the error information related to a data file， when an internal read fails on that file？（）

• A、V$DATAFILE
• B、V$DATAFILE_HEADER
• C、DBA_DATA_FILES
• D、V$DBFILE
• E、V$DATAFILE_ERRORS

第16题：

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

第17题：

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

第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题：

Which of the following dynamic view would you query to identify the online CURRENT redo log group？（）

• A、V$LOG
• B、V$LOFHIST
• C、V$LOGFILE
• D、V$LOG_HISTORY

第20题：

第21题：

第22题：

第23题：

第24题：