Which result or results will you obtain for each Transact-SQL statement?

DRAG DROP

Your Microsoft SQL Server database contains tables as shown below.

You have tables that were created by running the following Transact-SQL statements:

The Product table contains 10,000 records. The maximum ProductID is 11,000.

There are 12 rows in the Category table. The maximum CategoryID is 12.

The Product table contains at least one product in every category.

Data in the tables was accidently modified. To correct this, you need to make some updates directly to the tables. You issue several statements.

Which result or results will you obtain for each Transact-SQL statement? To answer, drag the appropriate results to the correct Transact-SQL statements. Each result may be used once. More than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

View Answer

Answer:

Explanation:

Box 1: The SET IDENTITY_INSERT command allows explicit values to be inserted into the identity column of a table.

Box 2: The Product table contains at least one product in every category.

Box 3:

Box 4: Bit is a data type that can take a value of 1, 0, or NULL.

References: https://docs.microsoft.com/en-us/sql/t-sql/data-types/bit-transact-sql?view=sql-server-2017 https://docs.microsoft.com/en-us/sql/t-sql/statements/set-identity-insert-transact-sql?view=sql­server-2017