Free Oracle 1Z0-055 Exam Dumps Questions & Answers

Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

• A.  You are not able to start up the database instance because the required database files are missing.
• B.  The user has dropped an important table that needs to be recovered.
• C.  The database files are corrupted when the database is open.
• D.  The archived log files are missing for which backup is not available.

The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario? (Choose two.)

• A.  The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
• B.  The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
• C.  The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
• D.  The optimizer selects the new plan for the execution of the SQL statement.
• E.  The optimizer adds the new plan to the plan history.

View the Exhibit to examine the error during the database startup.
You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:
RMAN> REPAIR FAILURE;
Which statement describes the consequence of the command?

• A.  The command only displays the advice and the RMAN script required for repair.
• B.  The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.
• C.  The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).
• D.  The command performs the recovery and closes the failures.

You are managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours:
ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H;
Which statement is true in this scenario?

• A.  All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
• B.  All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
• C.  It starts the ASM fast mirror resync.
• D.  It drops all disk paths from the dga disk group.

You executed the following PL/SQL block successfully:
VARIABLE tname VARCHAR2(20)
BEGIN
dbms_addm.insert_finding_directive (NULL, DIR_NAME=>'Detail CPU Usage',
FINDING_NAME=>'CPU Usage',
MIN_ACTIVE_SESSIONS=>0, MIN_PERC_IMPACT=>90);
:tname := 'database ADDM task4';
dbms_addm.analyze_db(:tname, 150, 162);
END;
/ Then you executed the following command:
SQL> SELECT dbms_addm.get_report(:tname) FROM DUAL;
The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis ____.

• A.  with the CPU Usage finding for snapshots not between 150 and 162
• B.  with the CPU Usage finding if it is less than 90
• C.  with the CPU Usage finding for snapshots below 90
• D.  without the CPU Usage finding if it is less than 90