單項選擇題

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

單項選擇題

Your production database is running in archivelog mode and you are using recovery manager （RMAN） with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday， the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted.
The steps to recover the damaged data files are follows：
1. Mount the database
2. Open the database
3. Recover the data file
4. Restore the data file
5. Make the data file offline
6. Make the data file online
Which option identifies the correct sequence that you must use to recover the data files？（）

A. 2，4，3
B. 1，4，3，2
C. 2，5，4，3，6
D. 5，2，4，3，6
E. 1，5，4，3，6，2

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？（）

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？（）