单选题Which of the following will begin a new unit of work?（）A The CONNECT statementB The first FETCH of a cursorC The BEGIN TRANSACTION statementD The first executable SQL statement

第1题：

第2题：

第3题：

Which of the following is the FIRST thing that should be done in order to begin reinstalling TCP/IP on the server？（）

• A、 Configure netsh settings in case of backup
• B、 Restart the server
• C、 Notify users
• D、 Uninstall TCP/IP

第4题：

If an external monitor is attached to a laptop and it does not work， which of the following actions should a technician take FIRST？（）

• A、Re-install the operating system.
• B、Open and close the cover.
• C、Use the function key to activate the monitor.
• D、Install new software for the keyboard.

第5题：

Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?（）

• A、The database manager will rollback the transaction in both applications.
• B、The database manager will rollback the transaction in one of the two applications.
• C、Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.
• D、Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.

第6题：

In which four clauses can a subquery be used? （）

• A、in the INTO clause of an INSERT statement
• B、in the FROM clause of a SELECT statement
• C、in the GROUP BY clause of a SELECT statement
• D、in the WHERE clause of a SELECT statement
• E、in the SET clause of an UPDATE statement
• F、in the VALUES clause of an INSERT statement

第7题：

Which of the following should be done FIRST when setting up a new p5-520 to be managed by a new HMC via a private network？（）

• A、Change passwords in ASMI
• B、Add the managed system to the HMC
• C、Connect the p5-520 to a power source
• D、Connect the HMC and the p5-520 server’s HMC1 port to the same network

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database， you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first？（）

• A、Create a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.
• B、Create a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’
• C、Create a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）
• D、Create services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport

第15题：

Several remote sales employees， who have come into the office this week， report that they are unable to get on the Internet， but no other users have reported similar issues.  The help desk hasescalated the issue and the case notes state that the users have IP addresses that begin with 169. Which of the following should the system administrator check FIRST？（）

• A、DHCP server
• B、Network switches
• C、DNS server
• D、Core router

第16题：

Which of the following database objects is considered executable using SQL?（）

• A、View
• B、Table
• C、Routine
• D、Package

第17题：

Which of the following will begin a new unit of work?（）

• A、The CONNECT statement
• B、The first FETCH of a cursor
• C、The BEGIN TRANSACTION statement
• D、The first executable SQL statement

第18题：

You are creating a stored procedure that will delete data from the Contact table in a SQL Server 2005 database. The stored procedure includes the following Transact-SQL statement to handle any errors that occur. BEGIN TRY   BEGIN TRANSACTION   DELETE FROM Person.Contact WHERE ContactID = @ContactID COMMIT TRANSACTION END TRY   BEGIN CATCH   DECLARE @ErrorMessage nvarchar（2000） DECLARE @ErrorSeverity int DECLARE @ErrorState int SELECT @ErrorMessage = ERROR MESSAGE（），@ErrorSeverity=ERROR SEVERITY（），@ErrorState = ERROR STATE（） RAISERROR （@ErrorMessage， @ErrorSeverity， @ErrorState） END CATCH；      You test the stored procedure and discover that it leaves open transactions. You need to modify the stored procedure so that it properly handles the open transactions. What should you do？（）

• A、Add a COMMIT TRANSACTION command to the CATCH block.
• B、Remove the COMMIT TRANSACTION command from the TRY block.
• C、Add a ROLLBACK TRANSACTION command to the CATCH block.
• D、Add a ROLLBACK TRANSACTION command to the TRY block.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：