Microsoft 70-442 最新题库分享

Microsoft 70-442 最新题库分享
Title    :  PRO:Design & Optimize Data Access by Using MS SQL Serv 2005
Version :  Demo

1. You are troubleshooting concurrency problems with the code that was originally developed on the SQL Server 2000 database. You discover

that there are excessive read locks on important tables. You need to resolve the problem. What should you do?
A. Set the transaction isolation level to REPEATABLE READ.
B. Set the transaction isolation level to SERIALIZABLE.
C. Set the ALLOW_SNAPSHOT_ISOLATION database option to ON.
D. Set the READ_COMMITTED_SNAPSHOT database option to ON.
Answer: D

2. You are designing a stored procedure that records a sale and decreases the inventory for the items that are being purchased. The stored

procedure contains the following code.
CREATE PROCEDURE UpdateSalesAndInventory (@ProductID int, @quantity int)
AS
SET IMPLICIT_TRANSACTION ON
INSERT INTO Sales.SalesOrder Values(@ProductID, @quantity)
UPDATE Inventory.ProductInventory
SET Quantity = Quantity - @quantity
WHERE ProductID = @ProductID
You run this stored procedure and discover that no updates are applied. You need to resolve the problem. What should you do?
A. Change SET IMPLICIT_TRANSACTION to OFF.
B. Use multiple active result sets (MARS) to execute the stored procedure.
C. Add logic to commit or roll back the transaction based on the successful updates of the data.
D. Add a BEGIN TRANSACTION statement to the stored procedure.
Answer: C

3. You need to design the data access model for available flight information. What should you use?
A. XML template queries
B. ActiveX data objects (ADO)
C. System.Data.DataSet
D. System.Data.DataReader
Answer: D

4. You need to design the transfer of sales data to the Accounting database. You are designing the stored procedure that will be used to

transfer the data. You must ensure that all requirements are fulfilled. Which Transact-SQL statement should you use first?
A. BEGIN TRANSACTION Acct WITH MARK 'Accounting'
B. BEGIN DISTRIBUTED TRANSACTION Acct
C. SET IMPLICIT_TRANSACTIONS ON
D. SAVE TRANSACTION Acct
Answer: A

5. You are a database developer for your company. You are creating a stored procedure that will use a Transact-SQL cursor to share the result

set with other statements in the stored procedure. This cursor must have a fixed membership where the order of the rows does not change. The

data in the rows that are retrieved through the cursor should be updatable. These updates should be viewable after they are made. While

implementing this cursor, you need to minimize memory usage regardless of the resulting effect on the speed of the cursor. You need to create

the stored procedure to fulfill these requirements. Which option should you use in the DECLARE CURSOR statement?
A. DYNAMIC
B. FAST_FORWARD
C. KEYSET
D. STATIC
Answer: C

相关的考试科目：70-293 认证，70-294 题库，70-298 认证考试题库和 70-640考试题库