Discussion :: SQL Server MCQs
- Point out the wrong statement :
A.
When the query processor parameterizes 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
|
Answer : Option C
Explanation :
AUDIT_ CHANGE_GROUP event is raised whenever CREATE SERVER AUDIT is issued.
Be The First To Comment