Free Download Oracle 1Z0-053 VCE Test Engine Full Version Now (301-310)

QUESTION 301
Which of the following are correct about block media recovery? (Choose all that apply.)

A.    Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTION.
B.    Logical corruptions are repairable by BMR.
C.    Physical corruptions are repairable by BMR.
D.    RMAN can use any backup for a BMR restore.
E.    ARCHIVELOG mode is not required if you have both a full and incremental backup for restore.

Answer: AC

QUESTION 302
While querying the EMPLOYEES table, you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified. Which RMAN command do you use to perform BMR and repair the corrupt block?

A.    RECOVER FILE=1201 BLOCK=1968;
B.    RECOVER CORRUPTION LIST;
C.    RECOVER DATAFILE 1201 BLOCK 1968;
D.    RECOVER BLOCK CORRUPTION LIST;
E.    None of the above

Answer: BC
Explanation:
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta2001.htm#RCMRF90244

QUESTION 303
To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?

A.    EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor
B.    EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuning
Advisor
C.    EM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors,
Automatic SQL Tuning Advisor
D.    Either B or C
E.    All of the above

Answer: D
Explanation:
http://blog.csdn.net/rlhua/article/details/14088141

QUESTION 304
When creating a SQL tuning set, which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values?

A.    Filter versions
B.    Filter loads
C.    Filter tasks
D.    Filter options

Answer: D
Explanation:
http://docs.oracle.com/cd/E11882_01/server.112/e10822/tdppt_sqltune.htm#TDPPT157

QUESTION 305
To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?

A.    From the Advisor Central home page, select the tuning task from the Advisor Tasks section.
B.    From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.
C.    From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.
D.    Either B or C.

Answer: A

QUESTION 306
Which of these appropriately describes the results of a manual SQL Tuning Advisor task?

A.    A list of SQL statements and recommendations for tuning
B.    A list of SQL statements that have been tuned by the Advisor, with before and after metrics
C.    Graphs showing the actual performance improvement made by the Advisor after it implemented the
recommended changes
D.    All of the above

Answer: A

QUESTION 307
Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?

A.    Create new indexes.
B.    Modify existing indexes.
C.    Implement partitioning on a nonpartitioned table.
D.    Create materialized views.
E.    All of the above

Answer: E

QUESTION 308
Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?

A.    SQL Access Advisor recommendations are automatically implemented.
B.    Individual SQL Access Advisor recommendations can be scheduled for implementation.
C.    All SQL Access Advisor recommendations for a specific task must be implemented at the same time.
D.    SQL Access Advisor recommendations are automatically scheduled for implementation during the
maintenance window.
E.    None of the above.

Answer: B

QUESTION 309
Which of the following represents the correct sequence of events for Database Replay?

A.    Capture, analyze, preprocess, replay
B.    Capture, preprocess, analyze, replay
C.    Capture, preprocess, replay, analyze
D.    Analyze, capture, preprocess, replay
E.    None of the above

Answer: C

QUESTION 310
Which of these recommendations should be followed before capturing a workload? (Choose all that apply.)

A.    Make sure your replay database has the same structure as the capture database, except without data.
B.    Make sure the replay and capture databases are similar in data content.
C.    Perform a clean shutdown and restart of the capture database before beginning a workload capture.
D.    Start the capture database in UNRESTRICTED mode, then start the capture.
E.    Define inclusion and exclusion filters.

Answer: BC

If you want to pass Oracle 1Z0-053 successfully, donot missing to read latest lead2pass Oracle 1Z0-053 dumps.
If you can master all lead2pass questions you will able to pass 100% guaranteed.

http://www.lead2pass.com/1Z0-053.html