Question

Point out the wrong statement.

(a) When the query processor parameterize the query, the parameter can appear in the audit event log instead of the column values of the query

(b) To access the triggering event we can use the EventData function in our DDL trigger

(c) AUDIT_DATABASE_CHANGE_GROUP event is raised whenever CREATE DATABASE AUDIT is issued

(d) None of the mentioned

The question was asked in semester exam.

The above asked question is from Schema Audit in chapter Monitoring and Auditing of SQL Server

Answer 1

Right answer is (c) AUDIT_DATABASE_CHANGE_GROUP event is raised whenever CREATE DATABASE AUDIT is issued

Explanation: AUDIT_ CHANGE_GROUP event is raised whenever CREATE SERVER AUDIT is issued.