MS SQL Server Test

Question 1: What is normalization?

Question 2: ACID stands for _______.

Question 3: What is Primary Key?

Question 4: A table can have more than one combination of columns that uniquely identify the row in a table; each combination is called_________.

Question 5: A column that automatically generates numeric values is called __________.

Question 6: What is the correct order of query operators in a SQL query?

Question 7: What are indexes?

Question 8: How many types of indexes in SQL server?

Question 9: RAID stands for ________.

Question 10: What is the difference between Primary key and Unique key?

Question 11: OLTP stands for _________.

Question 12: Which of the followings are the types of locks in SQL Server?

Question 13: What are the authentication modes in SQL Server?

Question 14: What is a trigger?

Question 15: What are the different types of trigger

Question 16: What are the different types of temporary tables in SQL server?

Question 17: Which of the following is not a valid data type in SQL server

Question 18: Which of the followings are valid Transaction levels in SQL Server?

Question 19: Which of the following keyword is used to raise an error in stored procedure?

Question 20: What are the different types of replication available in SQL server?