Oracle 11G OCP 1Z0-053 206

(206)Which statements are true regarding the Query Result Cache?(Choose all that apply.)

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.

答案:(A、C)

解析:

B(X),Result cache是放在共享池中的。不是只针对同一个session

The read-consistent snapshot used to build the result must retrieve the most current committed state of the data.

The query points to an explicit point in time using flashback query.

C,支持闪回查询

D(X)

《Performance Tuning Guide》 7.6.4.2

请使用浏览器的分享功能分享到微信等