SQL Server DB Objects MCQs

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

Answer: D

Replication in SQL Server is a process to synchronize data across multiple servers. It is also a method to recover from failures.

Visit types of replication in SQL Server for more information.

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

Answer: B

The UNION statement is used to combine the results of two or more tables with matching columns. Union eliminates duplicate rows from the output whereas UNON ALL includes all rows from the tables being joined including duplicates.

Visit UNION ALL statements for information.

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

Answer: A, B

A View is a virtual table whose contents are defined by a query. Unless indexed, a view does not exist as a stored set of data in the database. It is stored as a query. Database users need not have access to the underlying base tables referenced in a view.

Visit View in SQL Server for more information.

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

Answer: A, C, D

There are 3 types of triggers in SQL Server.

DML triggers are fired when an INSERT, UPDATE, or DELETE event occurs on a table.

DDL triggers are automatically invoked when a CREATE, ALTER, or DROP event occurs in a database.

The Logon trigger is invoked when a LOGON event is raised when a user session is established.

Visit Triggers in SQL Server for more information.

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

Answer: B, C

User-defined functions are created by the database user. There are 2 types of UDFs:

Scalar functions: The function that returns a single data value is called a scalar function.

Table-valued functions: The function that returns multiple records as a table data type is called a Table-valued function. It can be a result set of a single select statement.

Visit User-defined Functions in SQL Server for more information.