> > >

Microsoft SQL Server MCQs

Which of the following is a valid syntax of the ALTER SERVER AUDIT statement used to enable a server audit?

ALTER SERVER AUDIT <audit_name> WITH (ENABLE=TRUE)

ALTER SERVER AUDIT <audit_name> SET (ENABLE=TRUE)

ALTER SERVER AUDIT <audit_name> WITH (STATE=ON)

ALTER SERVER AUDIT <audit_name> SET (STATE=ON)

Answer

Correct Answer: ALTER SERVER AUDIT <audit_name> WITH (STATE=ON)

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Microsoft SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it