COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -To disable auditing on a SQL Server instance, select the instance in the Explore Activity tree, and then click Disable Auditing in the Summary tab. This action disables auditing at the SQL Server instance level for all databases.
Detailed explanation-2: -The audit disable command disables an audit device at a given path, if one exists. This command is idempotent, meaning it succeeds even if no audit device is enabled at the path. Once an audit device is disabled, no future audit logs are dispatched to it. The data associated with the audit device is unaffected.
Detailed explanation-3: -3. Which of the following object is only available for audit actions in Create Server Audit Specification? Explanation: Object Name is the name of the object to audit.It does not apply to audit groups.