Microsoft
70-433 · Question #72
70-433 Question #72: Real Exam Question with Answer & Explanation
The correct answer is C. CREATE TRIGGER TRG_TABLES_ON_FIRST. See the full explanation below for the reasoning.
Question
You are responsible for a SQL Server database. You require the tables to be added or altered only on the first day of the month. You need to ensure that if the tables are attempted to be modified or created on any other day, an error is received and the attempt is not successful. Which Transact-SQL statement should you use?
Options
- ACREATE TRIGGER TRG_TABLES_ON_FIRST
- BCREATE TRIGGER TRG_TABLES_ON_FIRST
- CCREATE TRIGGER TRG_TABLES_ON_FIRST
- DCREATE TRIGGER TRG_TABLES_ON_FIRST ON ALL SERVER FOR ALTER_DATABASE
Community Discussion
No community discussion yet for this question.