OCP 1Z0 053 123

123.What two statements are true regarding the recommendations receiv http:// ed 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 

http://docs.oracle.com/cd/E11882_01/server.112/e41573/advisor.htm#PFGRF95259

A workload consists of one or more SQL statements, plus statistics and attributes that fully describe each statement. A full workload contains all SQL statements from a target business application. A partial workload contains a subset of SQL statements. The difference is that for full workloads SQL Access Advisor may recommend dropping unused materialized views and indexes.

http://docs.oracle.com/cd/E11882_01/server.112/e41573/advisor.htm#PFGRF94909
The Advisor may recommend partitioning an existing unpartitioned base table to improve query performance.

http://docs.oracle.com/cd/E11882_01/server.112/e41573/advisor.htm#PFGRF94876
SQL Access Advisor index recommendations include bitmap,function-based, and B-tree indexes. A bitmap index offers a reduced response time for many types of ad hoc queries and reduced storage requirements compared to other indexing techniques. Bitmap indexes are most commonly used in a data warehouse to index unique or near-unique keys. SQL Access Advisor materialized view recommendations include fast refreshable and full refreshable MVs, for either general rewrite or exact text match rewrite.