Free Oracle 11gocmu Exam Dumps Questions & Answers

Which command is used to configure RMAN to perform a compressed backup for every backup executed?

• A.CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
• B.BACKUP DATABASE COMPRESS
• C.BACKUP AS COMPRESSED BACKUPSET DATABASE
• D.CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS
• E.BACKUP AS COMPRESSED COPY OF DATABASE

The ADMIN_EMP table has columns EMPNO, ENAME, DEPTNO, and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table?

• A.The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.
• B.The materialized view should have a complete refresh performed after the online table redefinition is completed.
• C.The materialized view, materialized log, and the index should be dropped and re-created after the online table redefinition is complete.
• D.The materialized view should have a fast refresh performed after the online table redefinition is completed.

Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?

• A.SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.
• B.SQL Access Advisor recommendations are automatically implemented.
• C.None of the above.
• D.All SQL Access Advisor recommendations for a specific task must be implemented at the same time.
• E.Individual SQL Access Advisor recommendations can be scheduled for implementation.

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 value assigned for the UNDO_RETENTION parameter
• B.Check the alert log file
• C.Query the V$RECOVERY_FILE_DEST_SIZE view
• D.Query the V$FLASHBACK_DATABASE_STAT view
• E.Query the V$FLASHBACK_DATABASE_LOG view

What is the proper command to shut down the database in a consistent manner?

• A.Shutdown nowait
• B.shutdown immediate
• C.Shutdown kill
• D.shutdown halt
• E.Shutdown abort