What set of Transact-SQL statements should you run?

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.

You query a database that includes two tables: Project and Task.

The Project table includes the following columns:

The Task table includes the following columns:

You plan to run the following query to update tasks that are not yet started:

UPDATE Task SET StartTime = GETDATE () WHERE StartTime IS NULL

You need to return the total count of tasks that are impacted by this UPDATE operation, but are not

associated with a project.

What set of Transact-SQL statements should you run?

A)

B)

C)

D)

A . Option A
B . Option B
C . Option C
D . Option D

View Answer

Answer: B

Explanation:

The WHERE clause of the third line should be WHERE ProjectID IS NULL, as we want to count the tasks that are not associated with a project.