Database Reference
In-Depth Information
10.
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 corrup-
tion is verified. Which RMAN command do you use to perform BMR and repair the
corrupt block? (Choose all that apply.)
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
11.
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
12.
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
13.
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
Search WWH ::
Custom Search