Chapter 6 Conditional Control: CASE Statements

Lab 6.1 ▪ Self-Review Answers

A1:
Questions Answers Comments
1) C The statements in a CASE construct are not executed sequentially. Rather, one group of statements or another will be selected to execute depending on how test conditions are evaluated.
A2:
Questions Answers Comments
2) B 
A3:
Questions Answers Comments
3) B The selector is evaluated only once, and the value of each expression is compared to the value of the selector sequentially.
A4:
Questions Answers Comments
4) A The behavior of a searched CASE construct is similar to the behavior of an IF statement. In other words, if all conditions of the CASE construct evaluate to NULL and there is no ELSE clause present, the control will ...

Get Oracle® PL/SQL® Interactive Workbook, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.