Oracle 11G OCP 1Z0-053 123

（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 atleast 10,000 rows.

D. It can recommend only B-tree indexes and not bitmap or function-based indexes.

答案：（B、C）

解析：

A（X），sql access advisor可以用sql tuning set對多條語句的訪問方式優化

D（X），SQL Access Advisor index recommendations include bitmap,function-based,and B-tree indexes.

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