Explanation:sys.fn_audit_file returns information from an audit file created by a server audit in SQL Server. 10. Which of the following statement is used to enable auditing from SQL Server ?
A. auditpol /set /subcategory:”application generated” /success:enable /failure:enable
B. polaudit /set /subcategory:”application generated” /success:enable /failure:enable
C. auditpolenable /set /subcategory:”application generated” /success:enable /failure:enable
D. auditenable /set /subcategory:”application generated” /success:enable /failure:enable
Answer:A
Explanation:sys.fn_audit_file returns information from an audit file created by a server audit in SQL Server. 10. Which of the following statement is used to enable auditing from SQL Server ?
A. auditpol /set /subcategory:”application generated” /success:enable /failure:enable B. polaudit /set /subcategory:”application generated” /success:enable /failure:enable C. auditpolenable /set /subcategory:”application generated” /success:enable /failure:enable D. auditenable /set /subcategory:”application generated” /success:enable /failure:enable