SQL Server interview questions part 26
SQL Server interview questions part 26
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Which of the following is server-level audit action group?
Correct Answer is : BACKUP_RESTORE_GROUP
2. Point out the wrong statement :
Correct Answer is : AUDIT_DATABASE_CHANGE_GROUP event is raised whenever CREATE DATABASE AUDIT is issued
3. AUDIT_CHANGE_GROUP event is raised whenever any audit is :
Correct Answer is : All of the mentioned
4. __________ could potentially lead to large audit records.
Correct Answer is : DATABASE_OBJECT_ACCESS_GROUP
5. You can use the handy event name of __________ to make sure your trigger covers all DDL events.
Correct Answer is : DDL_DATABASE_LEVEL_EVENTS
6. DDL Trigger can capture the information about the EVENT that fired it by using __________ function.
Correct Answer is : EVENTDATA()
7. Which of the following database level event si raised whenever a REFERENCES permission is checked.
Correct Answer is : REFERENCES
8. Point out the correct statement :
Correct Answer is : In versions of SQL Server through SQL Server 2014, sub-securables cannot use brackets in the form ‘[sub name]’. Use ‘sub name’ instead
9. _________ returns a list of the permissions effectively granted to the principal on a securable.
Correct Answer is : sys.fn_my_permissions
10. Syntax for fn_my_permissions function in SQL Server 2014 is :
Correct Answer is : fn_my_permissions ( securable , ‘securable_class’ )
11. Point out the wrong statement :
Correct Answer is : The SCHEMA securable scope contains the USER securables
12. The schema securable scope contains the following securables:
Correct Answer is : Object
13. Which of the following returns a row for each security principal in a SQL Server database ?
Correct Answer is : sys.database_principals
14. Any SQL Server authentication login can see ________ login name.
Correct Answer is : Own and sa
15. To add or remove server role membership use :
Correct Answer is : ALTER SERVER ROLE
16. 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 ] } [ ; ]
Correct Answer is : Specifies the new name of the user-defined server role
17. Service broker was added to SQL Server ___________
Correct Answer is : 2005
18. Point out the correct statement :
Correct Answer is : Loosely coupled applications are supported by the Service broker
19. There are _________ components of the Service broker in SQL Server.
Correct Answer is : 3
20. Which of the following service broker component defines the infrastructure used for exchanging messages between instances ?
Correct Answer is : Conversation
