Oracle OCP 1Z0 053 Q123(SQL Access Advisor)
123.What two statements are true regarding the recommendations received from the SQL Access Advisor?
(Choose two.)
A. It cannot generate recommendations that support multiple workload queries.
B. It can recommend partitioning on tables provided that the workloads have some predicates and joins
on the columns of the NUMBER or DATE type.
C. It can recommend partitioning only on tables that have at least 10,000 rows.
D. It can recommend only B-tree indexes and not bitmap or function-based indexes.
Answer: BC
D选项：SQL Access Advisor index recommendations include bitmap, function-based, and B-tree indexes.
参考：http://blog.csdn.net/jgmydsai/article/details/37600165
(Choose two.)
A. It cannot generate recommendations that support multiple workload queries.
B. It can recommend partitioning on tables provided that the workloads have some predicates and joins
on the columns of the NUMBER or DATE type.
C. It can recommend partitioning only on tables that have at least 10,000 rows.
D. It can recommend only B-tree indexes and not bitmap or function-based indexes.
Answer: BC
D选项：SQL Access Advisor index recommendations include bitmap, function-based, and B-tree indexes.
参考：http://blog.csdn.net/jgmydsai/article/details/37600165
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8520577/viewspace-2074164/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
