单选题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 processB Server

第1题：

You are configuring SQL1 so that the distributed query in the Sales database can access data in the CRM database on SQL2. You create a linked server for SQL2， and you create a linked server login that uses impersonation.Now， you need to ask the network administrator to configure SQL1. Which two tasks should you ask the administrator to perform？（）

• A、Add the user account that is used by the SQL Server service to the local Administrators group.
• B、Enable the Do not trust this user for delegation Active Domain property for the user account that is used by the SQL Server service.
• C、Create a Service Principal Name （SPN） for the user account that is used by the SQL Server service.
• D、Enable the Trusted for delegation Active Domain property for the user account that is used by the SQL Server service.

第2题：

Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?（）

• A、REVOKE ACCESS ON DATABASE FROM USER bob
• B、REVOKE CONNECT ON DATABASE FROM USER tom
• C、REVOKE tom FROM ACCESS ON DATABASE BY USER bob
• D、REVOKE tom FROM CONNECT ON DATABASE BY USER bob

第3题：

第4题：

You executed the following query：  SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）

• A、 It would return information regarding only the last committed transaction.
• B、 It would return only the active transactions in all the undo segments in the database.
• C、 It would return only the committed transactions in all the undo segments in the database.
• D、 It would return both active and committed transactions in all the undo segments in the database.
• E、 It would return information regarding the transactions that began and were committed in the last 30 minutes.

第5题：

All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’；3 rows deleted. The SYS user opens a new session after HR executed the above commands.  Which sessions can see theeffect of the UPDATE and DELETE commands（）

• A、All sessions of the HR user only
• B、All sessions of the HR user and the SYS user
• C、The session of the HR user that executed the commands
• D、All the sessions for which the database users have access privilege to the PERSONS table

第6题：

Users of your web application have requested that they should be able to set the duration of their sessions.So for example， one user might want a webapp to stay connected for an hour rather than the webapp’sdefault of fifteen minutes； another user might want to stay connected for a whole day. Furthermore， youhave a special login servlet that performs user authentication and retrieves the User object from the database. You want to augment this code to set up the user’s specified session duration. Which codesnippet in the login servlet will accomplish this goal？（）

• A、User user = // retrieve the User object from the database session.setDurationInterval（user.getSessionDuration（））；
• B、User user = // retrieve the User object from the database session.setMaxDuration（user.getSessionDuration（））；
• C、User user = // retrieve the User object from the database session.setInactiveInterval（user.getSessionDuration（））；
• D、User user=//retrieve the User object from the database session.setDuration（user.getSessionDuratio（））；
• E、User user = // retrieve the User object from the database session.setMaxInactiveInterval（user.getSessionDuration（））；

第7题：

All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions： SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.  SQL> DELETE FROM persons WHERE exp=’Y’； 3 rows deleted.  The SYS user opens a new session after HR executed the above commands.  Which sessions can seethe effect of the UPDATE and DELETE commands （）

• A、all sessions of the HR user only
• B、all sessions of the HR user and the SYS user
• C、the session of the HR user that executed the commands
• D、all the sessions for which the database users have access privilege to the PERSONS table

第8题：

第9题：

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)

第10题：

You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement：   SQL>EXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE   （PLAN => ’SALES_PLAN’，   GROUP_OR_SUBPLAN => ’MANAGERS’，   CPU_P1 => 100， CPU_P2 =>0，   SWITCH_GROUP => ’CLERKS’，   SWITCH_TIME_IN_CALL => 600）；   A user， SCOTT， who is assigned to the MANAGERS group， starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete？（）  

• A、 The query starts under the CLERKS group and the user， SCOTT， switches back to the MANAGERS group after the query completes.
• B、 The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.
• C、 The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.
• D、 The query starts under the MANAGERS group， the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes， and then switches back to the MANAGERS group after the query completes.