Free Oracle 1Z0-050 Exam Dumps Questions & Answers

Which two statements are true regarding the functionality of the remap command in ASMCMD? (Choose two.)

• A.  It repairs blocks that have read disk I/O errors
• B.  It repairs blocks by always reading them from the mirror copy and writing them to the original location.
• C.  It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.
• D.  It checks whether the alias metadata directory and the file directory are linked correctly.

You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?

• A.  The tuned plan is added to the fixed SQL plan baseline as a fixed plan.
• B.  The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
• C.  The tuned plan is not added to the SQL plan baseline.
• D.  The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.

You executed the following commands in an RMAN session for your database instance that has failures:
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session:
RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?

• A.  It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.
• B.  It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
• C.  It produces a warning for new failures before advising for CRITICAL and HIGH failures.
• D.  It produces advice only for new failures and the failures listed in the last LIST FAILURE
  command are ignored.

You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements will be true in this scenario? (Choose all that apply.)

• A.  The ASM migrates the extents from the unavailable disk to the remaining disks.
• B.  The disk is immediately dropped from the disk group.
• C.  The ASM tracks the extents that are modified during the outage.
• D.  The disk automatically goes offline.

You issued the following RMAN command to back up the database: RMAN> RUN{ ALLOCATE CHANNEL c1 DEVICE TYPE Sbt BACKUP DATABASE TAG quarterly KEEP FOREVER RESTORE POINT FY06Q4;}
Which two statements are true regarding the backup performed? (Choose two.)

• A.  Archived redo log files are backed up along with data files
• B.  Archived log files are backed up along with data files, and the archived log files are deleted.
• C.  Only data files are backed up and a restore point named FY06Q4 is created.
• D.  The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.