Which statements are true regarding the Query Result Cache?()
A: A It can be set at the system, session, or table level.
B: B It is used only across statements in the same session.
C: C It can store the results from normal as well as flashback queries.
D: D It can store the results of queries based on normal,temporary,and dictionary tables.
A: A It can be set at the system, session, or table level.
B: B It is used only across statements in the same session.
C: C It can store the results from normal as well as flashback queries.
D: D It can store the results of queries based on normal,temporary,and dictionary tables.
举一反三
- Which statements are true regarding the Query Result Cache?() A: A It can be set at the system, session, or table level. B: B It is used only across statements in the same session. C: C It can store the results from normal as well as flashback queries. D: D It can store the results of queries based on normal,temporary,and dictionary tables.
- Which two are true regarding external tables? () A: AExternal tables can be updated. B: BExternal tables are read-only tables. C: CIndexes can be created on external tables. D: DIndexes cannot be created on external tables.
- Which statement is true regarding synonyms?() A: Synonyms can be created only for a table B: Synonyms are used to reference only those tables that are owned by another user C: A public synonym and a private synonym can exist with the same name for the same table D: The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid
- Which statements are true regarding listeners() A: Listeners use only the TCP/IP protocol. B: Multiple listener processes can run simultaneously on a host. C: Multiple database instances can be registered with a single listener. D: The listener-related errors can be traced only at the administrative level. E: Only one database instance can be registered with a single listener at any time
- Which two statements are true regarding the execution of the correlated sub-queries?Choose two.() A: The nested query executes after the outer query returns the row. B: The nested query executes first and then the outer query executes C: The outer query executes only once for the result returned by the inner query. D: Each row returned by the outer query is evaluated for the results returned by the inner query