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?