READ Free Dumps For Oracle- 1z0-060
Question ID 2113 | You notice that the performance of your production 24/7 Oracle database significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. |
Option A | A. Enable Memory Access Mode, which reads performance data from SGA. |
Option B | B. Use emergency monitoring to fetch data directly from SGA analysis. |
Option C | C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots. |
Option D | D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring. |
Option E | E. Run ADDM in diagnostic mode |
Correct Answer | B |
Question ID 2114 | You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. |
Option A | A. ASM disk groups with ASM disks consisting of Exadata Grid Disks. |
Option B | B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array |
Option C | C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files |
Option D | D. Database files stored in ZFS and accessed using conventional NFS mounts. |
Option E | E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature |
Option F | F. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays |
Correct Answer | A,E,F |