SQL Notification Services Interview Questions

 
1.
How does Notification Services Work?
2.
What are Notification services?
3.
Explain architecture of SQL Server Notification services?
4.
What are the basic components of Notification services?
5.
What are the restrictions applicable while creating views?
6.
Define Primary and Unique key?
7.
Explain the difference between a primary key and a unique key?
8.
Define Distributed Query and Linked Server?
9.
What is Distributed Queries?
10.
What is a linked server?
11.
Explain OPENQUERY function and OPENROWSET function?
12.
Define transaction and transaction isolation levels?
13.
What is Isolation Levels?
14.
Define data, entity, domain and referential integrity?
15.
What are the lock types?