READ Free Dumps For Microsoft- 70-461
Question ID 15094 | You use Microsoft SQL Server 2012 to develop a database application. |
Option A | Scalar-valued function |
Option B | Inline function |
Option C | User-defined data type |
Option D | Stored procedure |
Correct Answer | D |
Question ID 15095 | You develop a Microsoft SQL Server 2012 database that contains a table named You need to create an audit record only when either the MobileNumber or HomeNumber |
Option A | CREATE TRIGGER TrgPhoneNumberChange ON Customers FOR UPDATE AS IF COLUMNS_UPDATED (HomeNumber, MobileNumber) - - Create Audit Records |
Option B | CREATE TRIGGER TrgPhoneNumberChange ON Customers FOR UPDATE AS IF EXISTS( SELECT HomeNumber from inserted) OR EXISTS (SELECT MobileNumber FROM inserted) - - Create Audit Records |
Option C | CREATE TRIGGER TrgPhoneNumberChange ON Customers FOR UPDATE AS IF COLUMNS_CHANGED (HomeNumber, MobileNumber) - - Create Audit Records |
Option D | CREATE TRIGGER TrgPhoneNumberChange ON Customers FOR UPDATE AS IF UPDATE (HomeNumber) OR UPDATE (MobileNumber) - - Create Audit Records |
Correct Answer | D |