Prentice Hall Oracle Plsql By Example 3Rd Edition [Electronic resources] نسخه متنی

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.

2)

B

3)

B

The selector is evaluated only once, and the value of each expression is compared to the value of the selector sequentially.

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 be passed to the first executable statement after END CASE.

5)

A

1)

A

A keyword here is

expression. You will recall that an expression returns a single value.

2)

C

3)

B

Similar to CASE statements, there are CASE and searched CASE expressions.

4)

A

The behavior of a CASE expression is similar to the behavior of a CASE statement. In other words, if all conditions of the CASE expression evaluate to NULL and there is no ELSE clause present, the expression returns NULL.

5)

A

As mentioned earlier, the keyword here is

expression. Because an expression returns a single value, it must return a single datatype.

1)

A

2)

B

The NULLIF function does the opposite of the NVL function. If the first expression is NULL, then NVL returns the second expression. If the first expression is not NULL, then NVL returns the first expression.

3)

B

When the literal NULL is used in the first expression of the NULLIF function, it causes a syntax error.

4)

A

5)

B

As long as one of the expressions in the COALESCE function does not contain NULL, the COALESCE function executes successfully. For example,

COALESCE(NULL, 5)

returns the value of 5. On the other hand,

COALESCE(NULL, NULL)

causes a syntax error.