PrepAway - Latest Free Exam Questions & Answers

What is the difference between the simple CASE expressi…

What is the difference between the simple CASE expression and the searched CASE expression?

PrepAway - Latest Free Exam Questions & Answers

A.
The simple CASE expression is used when the database recovery model is simple, and the searched CASE
expression is used when it’s full or bulk logged.

B.
The simple CASE expression compares an input expression to multiple possible expressions in the WHEN
clauses, and the searched CASE expression uses independent predicates in the WHEN clauses.

C.
The simple CASE expression can be used anywhere in a query, and the searched CASE expression can be used
only in the WHERE clause.

D.
The simple CASE expression can be used anywhere in a query, and the searched CASE expression can be used
only in query filters (ON, WHERE, HAVING).


Leave a Reply