It is built by Automatic Tuning Optimizer.
It cannot be stored persistently in the data dictionary.
It can be used by the query optimizer automatically.
It can be created manually by using the CREATE PROFILE command.
第1题:
Which two statements are true regarding the USING clause in table joins?()
第2题:
Which two statements about subqueries are true? ()
第3题:
A. It is built by Automatic Tuning Optimizer.
B. It cannot be stored persistently in the data dictionary.
C. It can be used by the query optimizer automatically.
D. It can be created manually by using the CREATE PROFILE command.
第4题:
Which two statements are true regarding subqueries? ()
第5题:
Which two statements are true regarding a PL/SQL package body?()
第6题:
Which two statements are true regarding views?()
第7题:
Which two statements about the SQL Management Base (SMB) are true? ()(Choose two.)
第8题:
A. It contains only SQL profiles generated by SQL Tuning Advisor.
B. It stores plans generated by the optimizer using a stored outline.
C. It is part of the data dictionary and stored in the SYSAUX tablespace.
D. It is part of the data dictionary and stored in the SYSTEM tablespace.
E. It contains the statement log, the plan history, plan baselines, and SQL profiles.
第9题:
Which two statements regarding a SQL profile are true?()
第10题:
Which two statements about subqueries are true?()