SQL Server DB Objects MCQs

Question 6: Identify the correct syntax to rename a column Address in the Employee table in SQL Server using T-SQL.

Question 7: What is the IDENTITY(seed, increment) used for?

Question 8: Which of the following is true about the Primary key?

Question 9: What are the different types of index in SQL Server?

Question 10: What are the different types of User-defined functions in SQL Server?