SQL Server Mock Test 7

10%

Question 1 of 10

1. Point out the wrong statement.

To access the triggering event we can use the EventData function in our DDL trigger

When the query processor parameterize the query, the parameter can appear in the audit event log instead of the column values of the query

None of the mentioned

AUDIT_DATABASE_CHANGE_GROUP event is raised whenever CREATE DATABASE AUDIT is issued

Question 1 of 10

Question 2 of 10

2. Which of the following statement is used to enable auditing from SQL Server?

polaudit /set /subcategory:"application generated" /success:enable /failure:enable

auditenable /set /subcategory:"application generated" /success:enable /failure:enable

auditpolenable /set /subcategory:"application generated" /success:enable /failure:enable

auditpol /set /subcategory:"application generated" /success:enable /failure:enable

Question 2 of 10

Question 3 of 10

3. Windows Authentication Mode is not available when an instance of SQL Server is running on ____________

All of the mentioned

Windows 95

Windows 98

Windows 7

Question 3 of 10

Question 4 of 10

4. Selecting the _________ option can allow unaudited activity which could violate your security policies.

Shut down

Break

Continue

Fail

Question 4 of 10

Question 5 of 10

5. Which of the following argument has option value 2 in sp_trace_create procedure?

SHUTDOWN_ON_ERROR

TRACE_FILE_ROLLOVER

All of the mentioned

TRACE_PRODUCE_BLACKBOX

Question 5 of 10

Question 6 of 10

6. Point out the wrong statement.

None of the mentioned

The entity that receives permission to a securable is called a principal

The SCHEMA securable scope contains the USER securables

A table is a securable

Question 6 of 10

Question 7 of 10

7. The Activity Monitor in SQL Server Management Studio graphically displays information about ______________

All of the mentioned

Locks

Blocked processes

User activity

Question 7 of 10

Question 8 of 10

8. Which of the following is the biggest disadvantage of SQL Server Authentication mode?

None of the mentioned

Allows SQL Server to support Web-based applications where users create their own identities

SQL Server Authentication cannot use Kerberos security protocol

Allows SQL Server to support older applications and applications provided by third parties that require SQL Server Authentication

Question 8 of 10

Question 9 of 10

9. Which of the following object is only available for audit actions in Create Server Audit Specification?

Audit Name

Object Name

All of the mentioned

Audit Action Type

Question 9 of 10

Question 10 of 10

10. ___________ encryption was introduced in SQL Server 2005 and is available in all editions of SQL Server.

Transparent Data Encryption

Column-level Encryption

BitLocker

None of the mentioned

Question 10 of 10