单选题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题：

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

第2题：

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

第3题：

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)

第4题：

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 
• E、 DBW0

第5题：

User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）

• A、UPDATE pets…
• B、SELECT….FROM pets
• C、INSERT INTO pets…
• D、ALTER TABLE pets…

第6题：

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. DB1 has a table which is named Table01 and a stored procedure named Procedure01. Procedure01 choose data from Table01 by using a sp_executesql Transact-SQL statement. You company security rules forbid users to access tables directly in any database. Look at the exception below: "Msg 229, Level 14, State 5, Line 1 The SELECT permission was denied on the object 'Table01', database 'DB1', schema 'dbo'." The exception is raised when Procedure01 is executed by users. You must make sure that e user can successfully execute Procedure1 complying with the company rules. So what action should you perform to achieve this goal?（）  

• A、You should execute the GRANT SELECT ON dbo.Table01 TO User1 Transact-SQL statement. 
• B、You should execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement. 
• C、You should alter Procedure01 and add the WITH EXECUTE AS OWNER option to its header 
• D、You should alter Procedure01 and add the EXECUTE AS USER = 'dbo' option immediately before the call to the sp_executesql stored procedure.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

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

第15题：

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.

第16题：

 A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）

• A、Acquire locks on table queried 
• B、Generate redo for statement 
• C、Fetch data from disk into memory 
• D、Write changes to disk

第17题：

Which four occur during the processing of a request using Oracle Shared Server？（）

• A、The dispatcher returns the response to the user.
• B、The dispatcher places the request into the request queue.
• C、The shared server places the response in the response queue.
• D、The response is handed off to the next available dispatcher.
• E、A shared server picks up the request from the request queue and processes the request.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：