SQL Server DB Objects MCQs

Question 11: What are the different types of replications in SQL Server?

• Transactional replication
• Merge replication
• Snapshot replication
• All of the above.

Question 12: When can you use a UNION statement with tables in SQL Server?

• To combine output from only two queries having the same number of columns.
• To combine output from multiple queries having the same number of columns as output.
• To combine output from multiple queries without having the matching number of columns.
• Can combine all kinds of queries without any restrictions.

Question 13: Which of the following statements are true regarding a VIEW in SQL Server?

• A view is a virtual table whose content is defined by a query.
• A view acts as a filter on the underlying tables referenced in the view.
• To access a View, users need to have permission to the underlying base tables of the view.
• A View always exists as a stored set of data in the database.

Question 14: Which of the following are the types of triggers in SQL Server?

• DDL Triggers
• Clustered triggers
• DML Triggers
• Logon trigger

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

• Non-clustered functions
• Scalar functions
• Table-valued functions
• Temp functions

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.

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.

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

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

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

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.