1 and 3
2, 3, and 5
1, 2, and 3
2, 3, 4, and 5
第1题:
Which two statements correctly describe the relation between a data file and the logical databasestructures()
第2题:
Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?()
第3题:
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.
第4题:
Which two statements about bigfile tablespaces are true? ()
第5题:
Which statements are true regarding the Query Result Cache?()
第6题:
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? ()
第7题:
Which statements listed below describe the data dictionary views() 1) These are stored in the SYSTEM tablespace. 2) These are the based on the virtual tables. 3) These are owned by the SYS user. 4) These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set to TRUE. 5) The V$FIXED_TABLE view can be queried to list the names of these views.
第8题:
A. It can be set at the system, session, or table level.
B. It is used only across statements in the same session.
C. It can store the results from normal as well as flashback queries.
D. It can store the results of queries based on normal, temporary, and dictionary tables.
第9题:
Which two statements about the SQL Management Base (SMB) are true? ()(Choose two.)
第10题:
Which two statements are true about simple views?()