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部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2074164/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle OCP 1Z0 053 Q258(SQL Repair Advisor)OracleSQLAI
- Oracle OCP IZ0-053 Q232(sql access advisor)OracleSQL
- Oracle OCP 1Z0 053 Q253(SQL Tuning Advisor)OracleSQL
- Oracle OCP 1Z0 053 Q406(sql tuning advisor)OracleSQL
- Oracle OCP 1Z0 053 Q403(Automatic SQL Tuning Advisor task)OracleSQL
- Oracle OCP 1Z0 053 Q298(SQL Tuning Advisor&GATHER_STATS_JOB)OracleSQL
- Oracle OCP 1Z0 053 Q40(DBMS_ADVISOR.QUICK_TUNE)OracleUI
- Oracle OCP 1Z0 053 Q493(SQL Performance Analyzer)OracleSQLORM
- SQL Access Advisor!SQL
- Oracle OCP 1Z0 053 Q246(SQL Plan Baselines)OracleSQL
- Oracle OCP 1Z0 053 Q650Oracle
- Oracle OCP 1Z0 053 Q324Oracle
- Oracle OCP 1Z0 053 Q27Oracle
- Oracle OCP 1Z0 053 Q49Oracle
- Oracle OCP 1Z0 053 Q10Oracle
- Oracle OCP 1Z0 053 Q685Oracle
- Oracle OCP 1Z0 053 Q454Oracle
- Oracle OCP 1Z0 053 Q500Oracle
- Oracle OCP IZ0-053 Q46(SQL Tuning Advisor Limited)OracleSQLMIT
- SQL Access Advisor(zt)SQL
- SQL Access Advisor 概要SQL
- SQL Access Advisor 與SQL Tuning AdvisorSQL
- Oracle OCP 1Z0 053 Q444(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q440(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q601Oracle
- Oracle OCP 1Z0 053 Q472(Locale)Oracle
- Oracle OCP 1Z0 053 Q525(ASM)OracleASM
- Oracle OCP 1Z0 053 Q292(NFS)OracleNFS
- Oracle OCP 1Z0 053 Q538(ASM)OracleASM
- Oracle OCP 1Z0 053 Q416Oracle
- Oracle OCP 1Z0 053 Q648(Flashback)Oracle
- Oracle OCP 1Z0 053 Q520Oracle
- Oracle OCP 1Z0 053 Q607Oracle
- Oracle OCP 1Z0 053 Q500(Rman)Oracle
- Oracle OCP 1Z0 053 Q707Oracle
- Oracle OCP 1Z0 053 Q28(INCREMENTAL)OracleREM
- Oracle OCP 1Z0 053 Q332Oracle
- Oracle OCP 1Z0 053 Q269Oracle