單項選擇題

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)

你可能感興趣的試題

View the exhibit and examine the output.

Which statement can be an inference from the output?（）

A. The FRA disk group has an asynchronous I/O bottleneck
B. The least number of I/Os are performed on the last data file in the list
C. The number of times that the backup or restore process directed the OS to wait until an I/O was complete is the highest for the last data file in the list
D. The number of times that the backup or restore process made an OS call to poll for I/O completion in Nonblocking mode is the least for the FRA disk group

單項選擇題

You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database.
The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）

A. Open the database in NORMAL mode
B. Open the database in read-only mode
C. Open the database in RESTRICTED mode
D. Open the database 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?（）

你可能感興趣的試題

View the exhibit and examine the output. Which statement can be an inference from the output?（）

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

View the exhibit and examine the output.

Which statement can be an inference from the output?（）