SQL Server DB Objects MCQs

Question 1: Which is the smallest numeric data type in SQL Server?

Question 2: What modes of authentications are supported in SQL Server?

Question 3: Which statement in the following is a valid check constraint?

Question 4: What are the different types of table relationships in SQL Server?

Question 5: What are the types of stored procedures?

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?