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
关于从SQL访问顾问收到的建议，哪两个陈述是真实的？
B、它可以建议在表上进行分区，如果这些表的工作负载在数字或日期类型的列上有一些谓词（判断）和连接。
C、它建议只有在有至少10,000行的表进行分区。
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
关于从SQL访问顾问收到的建议，哪两个陈述是真实的？
B、它可以建议在表上进行分区，如果这些表的工作负载在数字或日期类型的列上有一些谓词（判断）和连接。
C、它建议只有在有至少10,000行的表进行分区。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2124431/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
1Z0-053 V13.02 Q573
下一篇：
1Z0-053 V13.02 Q369
请登录后发表评论
登录
全部评论
