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?