Question

The BEGIN and END statements are used when ____________

(a) A WHILE loop needs to include a block of statements

(b) An element of a CASE expression needs to include a block of statements

(c) An IF or ELSE clause needs to include a block of statements

(d) All of the mentioned

The question was posed to me in an interview.

Question is from Procedural Flow in division Developing with SQL Server of SQL Server

Answer 1

Correct answer is (d) All of the mentioned

The explanation is: A BEGIN and END statement block must contain at least one Transact-SQL statement.