多项选择题
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
-
多项选择题
Which of the following files cannot be backed up by RMAN? ()(Choose all that apply.)
A. Database datafiles
B. Control files
C. Online redo logs
D. Database pfiles
E. Archived redo logs
-
单项选择题
Whatcommandwouldyouissuetoenableautomatedbackupsofcontrolfiles?()
A. alter database controlfile autobackup on
B. alter system controlfile autobackup on
C. configure controlfile autobackup on
D. enable controlfile autobackup
