Which Transact-SQL query should you use? You develop a Microsoft SQL server 2012 database that contains a table named customers. This table has two columns mobile number and home number per each customer. You need to create an audit record only when either the mobile number or home number column is updated.
A. Create trigger trgphonenumberchangeon customers for updates columns_updated (home number, mobile number)- - create audit records.
B. Create trigger trgphonenumberchangeon customers for updates exists( select the home number from inserted) or exists (select mobile number from inserted)- - create audit records.
C. Create trigger trgphonenumberchangeon customers for updates columns_changed (home number, mobile number)- - create audit records.
D. Create trigger trgphonenumberchangeon customers for updates update (home number) or update (mobile number)- - create audit records

Change Image    Delete