多項選擇題

The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option？（）

A. Control files
B. Password files
C. Inactive online redo log file
D. Archived log files required to perform recovery
E. Newly created tablespace which is not backed up

在線練習

你可能感興趣的試題

單項選擇題

Your database interface is running. A user SCOTT starts a SQL Plus session， and issues the following query：
SQL> SELECT FROM sales；
Which process would retrieve the result from the database and return it to the client program？（）

A. User process
B. Server process
C. System Monitor （SMON）
D. Process Monitor （PMON）
E. Checkpoint process （CKPT）

多項選擇題

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation？（）

A. The backup as copy can only be taken to disk
B. The backup as copy can only be taken to tape
C. Backup can be performed only when the instance is shutdown
D. Backup will constitute all used and unused blocks in the database

The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option？（）

你可能感興趣的試題

Your database interface is running. A user SCOTT starts a SQL *Plus session， and issues the following query： SQL> SELECT * FROM sales； Which process would retrieve the result from the database and return it to the client program？（）

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation？（）

The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option？（）

Your database interface is running. A user SCOTT starts a SQL Plus session， and issues the following query：
SQL> SELECT FROM sales；
Which process would retrieve the result from the database and return it to the client program？（）