多项选择题
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
相关考题
-
单项选择题
Given the following RMAN commands，choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.（） a. restore database b. recover database c. shutdown immediate d. startup e. restore archivelog all f. alter database open
A. a， b， c， d， e， f
B. c， b， a， d， e， f
C. c， b， a， d， f
D. c， a， b， d
E. c， a， e， b， d， f -
多项选择题
What recommendations does the SQL Access Advisor provide for optimizing SQL queries?（） (Choose all that apply.)
A. selection of SQL plan baselines
B. partitioning of tables and indexes
C. creation of index-organized tables
D. creation of bitmap, function-based, and B-tree indexes
E. optimization of materialized views for maximum query usage and fast refresh -
单项选择题
RMAN provides more granular catalog security through which feature?（）
A. Virtual private database
B. Virtual private catalog
C. RMAN virtual database
D. RMAN secure catalog
E. Oracle Database Vault
