Oracle OCP 1Z0-053 Q206(Query Result Cache)

abstractcyj發表於2016-03-23
Oracle

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.
Answer: AC

A肯定是對的，從文件來看，臨時表，資料字典相關的查詢結果是不支援的，所以D錯誤

15.2.4.3 Restrictions for the Result Cache

Results cannot be cached when the following objects or functions are in a query:

  • Temporary tables and tables in the SYS or SYSTEM schemas

  • Sequence CURRVAL and NEXTVAL pseudo columns

  • SQL functions CURRENT_DATE, CURRENT_TIMESTAMP, LOCAL_TIMESTAMP, USERENV/SYS_CONTEXT (with non-constant variables), SYS_GUID, SYSDATE, and SYS_TIMESTAMP

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2062675/，如需轉載，請註明出處，否則將追究法律責任。

相關文章