QUESTION 1
Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
A. The user has dropped an important table that needs to be recovered.
B. The database files are corrupted when the database is open.
C. You are not able to start up the database instance because the required database files are missing.
D. The archived log files are missing for which backup is not available.
Answer: BC
QUESTION 2
Examine the following values of the initialization parameters in the database having the SID ORCL:
BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump
CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump
DIAGNOSTIC_DEST=
The environment variables have the following value:
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
What is the location of the Automatic Diagnostic Repository (ADR) home?
A. /u01/app/oracle/product/11.1.0/db_1
B. /u01/app/oracle
C. $ORACLE_HOME/bdump
D. $ORACLE_HOME/log
Answer: B
QUESTION 3
Observe the following PL/SQL block:
BEGIN
dbms_spm.configure(‘SPACE_BUDGET_PERCENT’, 30);
END;
Which statement is correct regarding the above PL/SQL block?
A. It automatically purges the SQL management objects when SMB occupies more than 30% of the
SYSAUX tablespace.
B. It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base (SMB).
C. It reserves 30% of the space in the SYSTEM tablespace for SMB.
D. It generates a weekly warning in the alert log file when SMB occupies more than 30% of the
SYSAUX tablespace.
Answer: D
Explanation:
http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_spm.htm#ARPLS68159
http://docs.oracle.com/cd/E11882_01/server.112/e41573/optplanmgmt.htm#PFGRF95123
QUESTION 4
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 disk is immediately dropped from the disk group.
B. The ASM tracks the extents that are modified during the outa
C. The ASM migrates the extents from the unavailable disk to the remaining disks.
D. The disk automatically goes offline.
Answer: BD
QUESTION 5
Which statements are true regarding table compression? (Choose all that apply.)
A. It saves disk space and reduces memory usage.
B. It saves disk space but has no effect on memory usage.
C. It incurs extra CPU overhead during DML as well as direct loading operations.
D. It incurs extra CPU overhead during DML but not direct loading operations.
E. It requires uncompress operation during I/O.
Answer: AC
QUESTION 6
You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task?
A. Enable Flashback Data Archive for the tables.
B. Specify undo retention guarantee for the database.
C. Enable supplemental logging for the database.
D. Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo
tablespace for that size.
E. Create Flashback Data Archive on the tablespace on which the tables are stored.
Answer: A
QUESTION 7
Which components are needed for successful and most efficient recovery.
A. The backup RB3 and the current online redo log files
B. the backup RB2 and the archived redo log files after the log sequence number 15622
C. Backup R81 and the archived redo log hies after the log sequence number 12871
D. The backup RB3 and the archived redo log files after the log sequence number 16721
Answer: D
QUESTION 8
You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup.
You want to re-create the missing disk group by using the ASMCMD md_restore command. Which of these methods would you use to achieve this? (Choose all that apply.)
A. Restore the disk group with the exact configuration as the backed-up disk group, using the same
disk group name, same set of disks, failure group configurations, and data on the disk group.
B. Restore the disk group with the exact configuration as the backed-up disk group, using the same
disk group name, same set of disks, and failure group configurations.
C. Restore the disk group with changed disk group specification, failure group specification, disk group
name, and other disk attributes.
D. Restore metadata in an existing disk group by passing the existing disk group name as an input
parameter.
Answer: BCD
QUESTION 9
Which statement describes the effect of table redefinition on the triggers attached to the table?
A. All triggers on the table are invalidated and are automatically revalidated with the next DML execution
on the table.
B. All triggers on the table are invalidated and must be manually recompiled before the next DML execution
on the table.
C. All triggers on the table remain valid.
D. Only triggers that are affected by the changes to the structure of the table are invalidated and automatically
revalidated with the next DML execution on the table.
Answer: A
QUESTION 10
You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?
A. Create and populate a SQL Tuning Set from the AWR on every Monday.
B. Change the RETENTION setting for the AWR snapshots to 7 days on Monday.
C. Create a repeating baseline template.
D. Insert a finding directive for future ADDM tasks.
Answer: C
Explanation:
http://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF94196
If you want to pass Oracle 1Z0-053 successfully, donot missing to read latest lead2pass Oracle 1Z0-053 practice tests.
If you can master all lead2pass questions you will able to pass 100% guaranteed.