Which of the following scenario makes use of BEGIN..END keyword redundant?

A) when an IF statement controls the execution of multiple Transact-SQL statement

B) when an IF statement controls the execution of only one Transact-SQL statement

C) when an IF statement controls the execution of one or more Transact-SQL statement

D) None of the above

Correct Answer : when an IF statement controls the execution of only one Transact-SQL statement

Explanation : Use the BEGIN and END statements anywhere a control-of-flow statement must execute a block of two or more Transact-SQL statements.

Top Trending Technologies MCQ's

Machine Learning

Artificial Intelligence

Natural Language Processing

Top Trending Technologies Interview Questions