多项选择题

Identify the three predefined server-generated alerts. （）

A. Drop User
B. Tablespace Space Usage
C. Resumable Session Suspended
D. Recovery Area Low On Free Space
E. SYSTEM Tablespace Size Increment

点击查看答案

上一题目录下一题

相关考题

多项选择题

Evaluate the following command and its output：
SQL>SELECT * FROM dba_temp_free_space；
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
LMTEMP 250609664 101048576 149561088
Which two statements correctly interpret the output？（）

A. FREE_SPACE indicates only the space that is currently unallocated.
B. ALLOCATED_SPACE indicates only the space currently allocated and in use.
C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.
D. ALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse.
E. FREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.

多项选择题

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.