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 pr

第1题：

第2题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. Your job is to manage a SQL Server 2005 database， and there are several indexes in the SQL Server 2005. A stored procedure should be written， and the procedure should be utilized to check the indexes for fragmentation.  From the following four Transact-SQL statements， which one should be utilized achieve the goal？（）

• A、To achieve the goal， DBCC DBREINDEX should be utilized.
• B、To achieve the goal， SELECT * FROM sys.indexes should be utilized.
• C、To achieve the goal， SELECT * FROM sys.dm_db_index_physical_stats should be utilized.
• D、To achieve the goal， DBCC INDEXDEFRAG should be utilized.

第3题：

第4题：

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

第5题：

Which statement correctly describes SQL and /SQL*Plus?（）

• A、Both SQL and /SQL*plus allow manipulation of values in the database.
• B、/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.
• C、/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.
• D、/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.

第6题：

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.

第7题：

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

第8题：

第9题：

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

第10题：

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