SQL Server Practice Test 7

1. Point out the wrong statement.

The sa account is a well-known SQL Server account and it is often targeted by malicious users

Windows authentication mode dramatically reduces the chances of error or oversight

All of the mentioned

Account administration details in windows mode is stored in passive directory

2. By using Windows Authentication, Windows groups can be created at the _________ level.

None of the mentioned

Domain

User

3. Which of the following stored procedure will stop the trace?

sp_trace_create.

sp_trace_setstatus

sp_stop_status

sp_trace_setfilter

4. Point out the wrong statement.

EncryptByKey returns NULL if the key is not open

All of the mentioned

EncryptByKey uses a symmetric key

You can use encryption in SQL Server for connections, data, and stored procedures

5. What is the syntax for fn_my_permissions function in SQL Server 2014?

fn_my_permissions ( 'securable' , securable_class)

fn_my_permissions ( securable , 'securable_class' )

fn_my_permissions ( 'securable' , 'securable_class' )

fn_my_permissions ( securable , securable_class )

6. Which of the following pair of technology is supported in SQL Server?

Mirroring and Replication

All of the mentioned

Mirroring and Clustering

Mirroring and Log Shipping

7. Which of the following scenario prefers failover cluster instance over stand alone instance in SQL Server?

High Confidentiality

High Availability

None of the mentioned

High Integrity

8. What is the role of WITH NAME in the following code?

ALTER SERVER ROLE server_role_name 
{
    [ ADD MEMBER server_principal ]
  | [ DROP MEMBER server_principal ]
  | [ WITH NAME = new_server_role_name ]
} [ ; ]

Removes the specified server principal from the server role

Adds the specified server principal to the server role

Specifies the new name of the user-defined server role

None of the mentioned

9. Which of the following tool is used for purpose of data auditing for SQL Server only?

SQL Audit

Idera

SQL Ninja

ApexSQL

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

Break

Continue

Shut down

Fail