单项选择题
Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）
A. only the control file, the current SPFILE, and data files
B. only the current SPFILE and data files if autobackup is disabled
C. only the data files and the archived redo logs
D. the control file, current SPFILE file, data files, and archived redo logs
相关考题
-
多项选择题
The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL> STARTUP; Which two activities are performed during a successful start up operation?（）
A. The databases configured to use the ASM instance are mounted
B. The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
C. ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started
D. ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters -
单项选择题
Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?（）
A. a cumulative level 1 backup
B. a differential level 1 backup
C. a full backup
D. a whole backup -
单项选择题
Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?（）
A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.
B. Capture the plans from the previous version using STS and then load them into the stored outline.
C. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).
D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.
