[单选]
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.

没有经营风险的企业也就没有财务风险。你的网络中包含一个独立的活动目录森林。你有50台便携计算机和50台桌面计算机。所有的计算机都具有32位的硬件。你计划通过自定义镜像部署Windows 7和10个公司应用程序到这些计算机。你需要使用最少的管理员行为来为这部署做好准备，你该怎么做？（）在一台计算机上，安装Windows 7和这些公司应用程序。在一台便携计算机和一台桌面计算机上，安装Windows 7和这些公司应用程序。在一台服务器上，安装并运行微软评估与企划工具包（MAP）。在一台服务器上，安装Windows自动安装工具包（AIK）并运行系统镜像管理器（Windows SIM）。简述HDV核酶的结构。 You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. You derive a new validation control from the BaseValidator class. The validation logic for the control is implemented in the Validate method in the following manner. protected static bool Validate(string value) { ... } You need to override the method that validates the value of the related control. Which override method should you use?（）

。

。简述学习的概念（或学习的心理实质）。

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

参考答案：

● 参考解析

本题暂无解析

当前位置：MCTS(70-431)题库

相关题目: