Multiple choice technology databases

Syntax for case structure?

  1. Case [ TRUE | selector_variable ]] When [criteria1 | expression1 ] then criteria1_statements; When [criteria1 | expression1 ] then Criteria2_statements; Else block statement; end;

  2. Case value case [criteria1 | expression1 ] then criteria1_statements; case [criteria1 | expression1 ] then Criteria2_statements; Else block statement; end case;

  3. Case [ TRUE | selector_variable ]] When [criteria1 | expression1 ] then criteria1_statements; When [criteria1 | expression1 ] then Criteria2_statements; Else block statement; end case;

  4. Case [ TRUE | selector_variable ]] Loop When [criteria1 | expression1 ] then criteria1_statements; When [criteria1 | expression1 ] then Criteria2_statements; Else block statement; end Loop;
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The CASE statement syntax is 'CASE [selector | TRUE] WHEN condition THEN statements ... END CASE'. Option C shows the correct structure with WHEN-THEN pairs and ends with 'END CASE'. Options A and D omit 'CASE' from END, and option B incorrectly uses 'case' as a keyword.

Keep practicing — related questions