Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?()
第1题:
A. Selection, projection, join
B. Difference, projection, join
C. Selection, intersection, join
D. Intersection, projection, join
E. Difference, projection, product
第2题:
A. Bind Variable Peeking
B. SQL Plan Baselines
C. Adaptive Cursor Sharing
D. Bind variable used in a SQL statement
E. Literals in a SQL statement
第3题:
Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?()
第4题:
Which two statements are true regarding the SQL Repair Advisor?()
第5题:
Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?()
第6题:
Which of the following cannot be used as input to the SQL Tuning Advisor?()
第7题:
Alice only
Alice and Reena
Alice, Reena, and Timber
Sue, Alice, Reena, and Timber
第8题:
It contains only the plan for the SQL statement executed by the user.
It contains the SQL text executed by the user and the bind variables used with it.
It contains the plan and statistics associated with the SQL statement executed by the user.
It contains the plan for the SQL statement executed by the user and the bind variables used with it
第9题:
Bind Variable Peeking
SQL Plan Baselines
Adaptive Cursor Sharing
Bind variable used in a SQL statement
Literals in a SQL statement
第10题:
The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.
第11题:
A text copy of the control file.
A binary copy of the control file.
A file containing a SQL statement which will re-create the database.
A file containing a SQL statement which will re-create the control file.
第12题:
The optimizer adds the new plan to the plan history.
The optimizer selects the new plan for the execution of the SQL statement.
The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
第13题:
A.
B.
C.
D.
第14题:
You issue this statement:ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What does the statement generate?()
第15题:
Which statement about the DVS engine is true?()
第16题:
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()
第17题:
Which of the following cannot be used as input to the SQL Tuning Advisor?() (Choose all that apply.)
第18题:
The SGA Tuning Advisor
The SQL Access Advisor
The SQL Tuning Advisor
The Memory Advisor
第19题:
The SGA Tuning Advisor
The SQL Access Advisor
The SQL Tuning Advisor
The Memory Advisor
第20题:
SELECT ename, salary*12 ‘Annual Salary’ FROM employees;
SELECT ename, salary*12 “Annual Salary” FROM employees;
SELECT ename, salary*12 AS Annual Salary FROM employees;
SELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”) FROM employees
第21题:
SQL Repair Advisor
SQL Optimizer
SQL Access Advisor
SQL Tuning Advisor
第22题:
The tuned plan is not added to the SQL plan baseline.
The tuned plan is added to the fixed SQL plan baseline as a fixed plan.
The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
第23题:
A single SQL statement provided by a user
An existing SQL Tuning Set (STS)
A preprocessed Database Replay workload
A schema name
SQL statement identified in EM as using excessive resources
第24题:
A single SQL statement provided by a user
An existing SQL Tuning Set (STS)
A preprocessed Database Replay workload
A schema name
SQL statement identified in EM as using excessive resources