SQL Server DB Objects MCQs

Question 16: A view in SQL Server is ___________.

• A temp table created when processing a query.
• A system table which created when the database gets created.
• A user-defined function returning a dataset.
• A virtual table whose contents are defined by a query.

Check Answer

Question 17: What are some characteristics of a database schema?

• A schema can belong to only one database.
• A schema can be shared by many databases.
• There are no restrictions on the number of objects in a schema.
• Schema ownership cannot be transferred.

Check Answer

Question 19: What is a valid syntax for creating a DDL trigger in SQL Server?

• CREATE TRIGGER trigger_nameON DATABASE FOR INSERT, UPDATE, DELETE AS BEGIN END
• CREATE TRIGGER trigger_name AS CREATE, ALTER, DROP BEGIN END
• CREATE TRIGGER trigger_name ON DELETE, DROP, ALTER BEGIN END
• CREATE TRIGGER trigger_name ON DATABASE FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE AS BEGIN END

Check Answer

Question 20: What is the SQL statement block to handle exceptions in SQL Server?

• BEGIN...END
• TRY...CATCH
• BEGIN...ROLLBACK
• TRY...COMMIT

Check Answer

Question 21: Identify the key characteristics of a clustered index

• Sort and store data rows in the table based on their key values.
• There can be one or more Clustered indexes on a table.
• Does not store data in leaf nodes.
• Doesn’t require additional disk space.

Check Answer