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.
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
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
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
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
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.
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
D. All of the above
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
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
E. None of the above.
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
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.
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.
|One Time Purchase||✔||✖||✖||✖||✖|
|100% Pass Guarantee||✔||✖||✖||✖||✖|
|100% Money Back||✔||✖||✖||✖||✖|