单选题The user is trying to execute a SELECT statement. Which of the following background processes will obtain data from a disk for the user?（）A DISPATCHER B USER C SERVER D LGWR EDBW0

第1题：

A Windows user is trying to get to a shared folder on a server but is receiving an error message that multiple connections to the same resource are not allowed. Which of the following tools can the technician use from the user’s workstation to get the user reconnected as quickly as possible？（）

• A、nbtstat with the/reload parameter
• B、nbtstat with the/resolved parameter
• C、net use with the/delete parameter
• D、net use with the/persistent parameter

第2题：

Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?（）

• A、REVOKE ADD, DELETE FROM USER tom ON TABLE tab1
• B、REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom
• C、REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1
• D、REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom

第3题：

第4题：

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)

第5题：

Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?（）

• A、REVOKE ALL PRIVILEGES FROM USER tom
• B、REVOKE ALL ON EMPLOYEE FROM USER tom
• C、REVOKE EXECUTE ON EMPLOYEE FROM USER tom
• D、REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom

第6题：

Examine the RMAN command： SWITCH DATAFILE ’/DISK3/user_data01.dbf’； Which command do you need to issue before you issue the above command， so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’？ （）

• A、RESTORE DATAFILE ’/DISK2/user_data01.dbf’
• B、RESTORE DATAFILE ’/DISK3/user_data01.dbf’
• C、SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’
• D、SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’

第7题：

Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?（）

• A、REVOKE SELECT FROM user2 ON TABLE org.tab1
• B、REVOKE SELECT ON TABLE org.tab1 FROM user2
• C、REVOKE READ ACCESS FROM user2 ON TABLE org.tab1
• D、REVOKE READ ACCESS ON TABLE org.tab1 FROM user2

第8题：

第9题：

The Oracle Shared Server architecture reduces memory usage by reducing the number of server processes required. To process a request for a server process， the following tasks are performed：   1.A shared server picks up the request from the request queue and processes the  request.  2.The dispatcher retrieves the response from the response queue.  3.A user sends a request to its dispatcher.  4.The dispatcher returns the response to the user.  5.The shared sever places the response on the calling dispatcher’s response queue.  6.The dispatcher places the request into the request queue in the SGA.   Put the above task in the order in which they are performed.（）

• A、3，1，6，2，5，4
• B、3，6，1，5，2，4
• C、3，1，2，3，4，5
• D、6，1，3，5，2，4
• E、6，3，1，2，4，5
• F、6，3，1，2，5，4

第10题：

Which statement is true regarding Oracle Shared Server architecture？（）

• A、A dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher. 
• B、Under the Oracle Shared Server architecture, client-user processes connect to shared user processes.
• C、Each dispatcher has its own request queue, which is monitored every three seconds by the dispatcher. 
• D、Oracle Shared Server required Oracle Net Service even if the client and shared server processes reside on the same machine.