Free Oracle 1Z0-050 Exam Dumps Questions & Answers

You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?

• A.  Take an immediate AWR snapshot.
• B.  Decrease the window size for the baseline.
• C.  Decrease the expiration time for the baseline.
• D.  Compute the baseline statistics.

Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)

• A.  It can be used to re-create the ASM disk group with its attributes.
• B.  It can be used to recover the damaged ASM disk group along with the data.
• C.  It can be used to gather information about a preexisting ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure.
• D.  It can be used to backup all data on ASM disks.

You want to perform the following operations for the DATA ASM disk group:
-Verify the consistency of the disk.
-Cross-check all the file extent maps and allocation tables for consistency. -Check whether the alias metadata directory and file directory are linked correctly. -Check that ASM metadata directories do not have unreachable allocated blocks.
Which command accomplishes these tasks?

• A.  ALTER DISKGROUP data CHECK FILE;
• B.  ALTER DISKGROUP data CHECK DISK;
• C.  ALTER DISKGROUP data CHECK;
• D.  ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;

View the Exhibit to observe the error.

You receive this error regularly and have to shut down the database instance to overcome the error. What can the solution be to reduce the chance of this error in future, when implemented?

• A.  increasing the value of SGA_MAX_SIZE
• B.  automatic memory management
• C.  setting the PRE_PAGE_SGA parameter to TRUE
• D.  locking the SGA in memory

Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

• A.  failures due to loss of connectivity-for example, an unplugged disk cable
• B.  failures that require no archive logs to be applied for recovery
• C.  failures when no standby database is configured
• D.  failures because a data file is renamed by error