1. How many types of locks are present in a database?
2. What are the types of indexes that are present inside a database?
3. What is the use of default key?
4. How default key is different from primary key?
5. What is difference between clustered, non-clustered and unique index?
6. How many indexes can be created on a table?
7. What will happen non-clustered index will be created on clustered index?