SQL Server DB Objects MCQs

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

• Int
• smallint
• tinyint
• Bit

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

• Windows Authentication
• SQL Server Authentication
• Role-based Authentication
• Cloud Authentication

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

• CONSTRAINT CHK_Salary(Salary > 10000)
• CHECK CHK_Emp_Sal(Salary > 0)
• CONSTRAINT CHK_Emp_Salary CHECK(Salary > 10000 AND Salary < 30000)
• CONSTRAINT CHK_EmpSal CHECK(Salary > 0)

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

• One-to-One
• One-to-Many
• Many-to-Many
• All of the above.

Question 5: What are the types of stored procedures?

• User-defined stored procedures
• System stored procedures
• Master stored procedures
• Inline stored procedures

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

• EXEC rename 'Employee.Address', 'NewAddress';
• rename ('Employee.Address', 'NewAddress, 'COLUMN') ;
• EXEC sp_rename_column 'Employee.Address', 'NewAddress';
• EXEC sp_rename 'Employee.Address', 'NewAddress', 'COLUMN';

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

• To declare an auto-generated integer identity column.
• To declare a primary key column.
• To declare a foreign key column.
• None of the above.

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

• A table can have only one primary key.
• Primary key can have one null value.
• The primary key uniquely identifies each row in a table.
• A primary key can be defined on only one column.

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

• System Index
• Clustered Index
• Non-clustered Index
• User-defined Index

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

• Scalar functions
• System functions
• Ranking functions
• Table-valued functions