单项选择题
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）
相关考题
-
多项选择题
YouwanttoperformanRMANbackupofdatabaseasacopy.Whichtwofactorswillyouconsiderwhileperformingthebackupoperation？（）
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 -
多项选择题
You executed the following command to drop a user： DROP USER scott CASCADE； Which two statements regarding the above command are correct？（）
A. All the objects of scott are moved to the Recycle Bin.
B. Any objects in the Recycle Bin belonging to scott are purged.
C. All the objects owned by scott are permanently dropped from the database.
D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
