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.

• 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