Oracle OCP 1Z0-053 Q206(Query Result Cache)
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博客 ” ，链接：https://blog.itpub.net/8520577/viewspace-2062675/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
