Oracle

1Z0-147 · Question #54

Which two conditions in a PL/SQL block cause an exception to occur? (Choose two.)

The correct answer is A. The SELECT statement does not return a row. B. The SELECT statement returns more than one row. See the full explanation below for the reasoning.

Question

Which two conditions in a PL/SQL block cause an exception to occur? (Choose two.)

Options

AThe SELECT statement does not return a row.
BThe SELECT statement returns more than one row.
CThe SELECT statement contains a GROUP BY clause.
DThe SELECT statement does not have a WHERE clause.
EThe datatypes in the SELECT list are inconsistent with the datatypes in the INTO clause.

How the community answered

(18 responses)

A
78% (14)
C
6% (1)
D
6% (1)
E
11% (2)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-147 Practice