Free Oracle 1Z1-052 Exam Dumps Questions & Answers

Which three are true about the Automatic Workload Repository (AWR)? (Choose three.)

• A.  It includes statistics that contain the number of rows per table.
• B.  By default, AWR data is retained for eight days.
• C.  AWR data is stored in the SYSAUX tablespace.
• D.  It is maintained by executing the PL/SQL procedures in the DBMS_STATS package.
• E.  It includes statistics that contain the number of distinct values per table column.
• F.  Automatic AWR snapshots are created by the Manageability Monitor (MMON) background process.

Note the following structures in your database server:
1 . Extents
2 . OS Blocks
3 . Tablespace
4 . Segments
5 . Oracle Data Block
Which option has the correct arrangement of these structures from the smallest to the largest?

• A.  1, 2, 3, 4, 5
• B.  5, 2, 1, 3, 4
• C.  2, 1, 5, 4, 3
• D.  2, 5, 1, 4, 3

Which command is used to display files that no longer conform to the backup retention policy?

• A.  SHOW DATAFILE BACKUP COPIES
• B.  LIST EXPIRED BACKUP
• C.  REPORT OBSOLETE
• D.  CROSSCHECK BACKUP

You execute the following command to change the status of the SALES tablespace:
SQL> ALTER TABLESPACE sales OFFLINE;
Which statements describe the effect of the command? (Choose all that apply.)

• A.  The tablespace would require recovery to go back online.
• B.  The sessions that subsequently try to access the objects in the SALES tablespace receivean error.
• C.  The new status of the SALES tablespace is recorded in the control file when the database instance is closed.
• D.  A checkpoint is taken on all data files that are associated with the SALES tablespace.

Which two are true about FAST_START_MTTR_TARGET? (Choose two.)

• A.  It is applicable only when the database is in ARCHIVELOG mode
• B.  A higher value increases the I/O overhead
• C.  A lower value increases the time taken to perform instance recovery
• D.  If it is set to 0, the MTTR Advisor is disabled
• E.  It is overridden by LOG_CHECKPOINT_INTERVAL