多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

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 the administrator of a SQL Server 2005 computer, and the computer is called SQL1. There are two databases on the SQL1, and the two databases are respectively named Production and DW. A new database named Staging is created. When the data are moving from the Production database into the DW database, the Staging database is utilized temporarily to store and manipulate data. Since you are the database administrator, you are required to make sure the points listed below. First, the tables should not be removed from the Staging database. Second, any attempts to have tables migrated should be logged. Third, your solution should not impact on other databases.  Which action should be performed to achieve the goal?()

  • A、To achieve the goal, a DML trigger on each table should be created to prevent deletion of data.
  • B、To achieve the goal, a DDL trigger should be created, and that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.
  • C、To achieve the goal, an event notification should be created to fire when the TRUNCATE TABLE Transact-SQL statement is submitted to the Staging database.
  • D、To achieve the goal, a DDL trigger should be created, and the ON ALL SERVER parameter is utilized by the DDL trigger.
正确答案:B
答案解析:
进入题库查看解析

微信扫一扫手机做题