Explore topic-wise MCQs in SQL Server.

This section includes 1 Mcqs, each offering curated multiple-choice questions to sharpen your SQL Server knowledge and support exam preparation. Choose a topic below to get started.

1.

Which of the following views log from a file that is named serverName Audit HIPPA_AUDIT.sqlaudit?

A. SELECT * FROM sys.fn_audit_file ( serverName Audit HIPPA_AUDIT.sqlaudit , default,default);
B. SELECT * FROM sys.fn_get_audit_file ( serverName Audit HIPPA_AUDIT.sqlaudit , default,default);
C. SELECT * FROM sys.fn_get_audit( serverName Audit HIPPA_AUDIT.sqlaudit , default,default);
D. None of the mentioned
Answer» C. SELECT * FROM sys.fn_get_audit( serverName Audit HIPPA_AUDIT.sqlaudit , default,default);
Discussion