Question 1

What does the 'CASE WHEN' statement resemble in everyday decision-making?

Accepted Answer

A set of 'if-then' rules

Answer

A mathematical formula

Answer

A data sorting technique

Answer

A programming function

Question 2

What is the purpose of the 'ELSE' keyword in a 'CASE WHEN' statement?

Accepted Answer

Defines what happens if none of the conditions are true

Answer

Marks the beginning of the statement

Answer

Ends the entire statement

Answer

Specifies the first condition

Question 3

In the syntax 'CASE WHEN condition1 THEN result1', what does 'condition1' represent?

Accepted Answer

A condition that is checked

Answer

The end of the statement

Answer

An action to be taken

Answer

The default result

Question 4

In the provided SQL example, what grade is assigned to a student who scores 85?

Accepted Answer

'B'

Answer

'C'

Answer

'Fail'

Answer

'A'

Question 5

What SQL clause starts the 'CASE WHEN' statement?

Accepted Answer

'CASE'

Answer

'THEN'

Answer

'WHEN'

Answer

'END'

Question 6

Which keyword is used to indicate the result of a true condition in 'CASE WHEN'?

Accepted Answer

'THEN'

Answer

'ELSE'

Answer

'CASE'

Answer

'WHEN'

Question 7

What will be the result for a student scoring 45 in the SQL example?

Accepted Answer

'Fail'

Answer

'C'

Answer

'A'

Answer

'B'

Question 8

What is indicated by the keyword 'END' in the 'CASE WHEN' statement?

Accepted Answer

Marks the end of the CASE statement

Answer

Indicates a condition

Answer

Specifies a result

Answer

Starts the statement

Question 9

How are the conditions evaluated in the 'CASE WHEN' statement?

Accepted Answer

In the order they are written

Answer

From lowest to highest

Answer

Randomly

Answer

In reverse order

Question 10

If no conditions in a 'CASE WHEN' statement are satisfied, which result is returned?

Accepted Answer

The default result specified in the ELSE clause

Answer

No result

Answer

The first condition's result

Answer

An error message