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 

多项选择题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

多项选择题Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line？（） Assume that the target database is called ORCL and that the recovery catalog database is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assume the environment is configured for the ORCL database.

A. rman target=/ catalog=/@rcat
B. rman target=/ catalog=rcat_own/rcat_own
C. rman target=/ catalog=rcat_own/rcat_own@RCAT
D. rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCAT
E. You cannot connect to the target database and the recovery catalog at the same time.