多项选择题
Which two statements regarding a SQL profile are true？（）
A. It is built by Automatic Tuning Optimizer.
B. It cannot be stored persistently in the data dictionary.
C. It can be used by the query optimizer automatically.
D. It can be created manually by using the CREATE PROFILE command.
相关考题
-
单项选择题
You executed the following command： RMAN> RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’； Which statement regarding the above command is correct？（）
A. The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy.
B. The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup.
C. Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.
D. Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails. -
单项选择题
You enable block change tracking. You issue the following command： BACKUP INCREMENTAL LEVEL 0 DATABASE； The next day，you issue the following command： BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE； Which statement about the use of the change tracking file is true？（）
A. RMAN reads the block change tracking file only when it performs the incremental level 0 backup.
B. RMAN reads the block change tracking file when it performs both incremental backups.
C. RMAN reads the block change tracking file only when it performs the incremental level 1 backup.
D. RMAN does not read the block change tracking file when it performs either incremental backup. -
多项选择题
IdentifythreekeyfeaturesofASM.（）
A. file striping
B. allocation unit mirroring
C. automatic disk rebalancing
D. automatic file size increment
E. automatic undo management
