oracle · 1z0-149 · Q605 · multiple_choice · topic_1

Examine this table in the SH schema: //IMG// User SH executes this code: //IMG// The program must terminate with a us…

Examine this table in the SH schema: //IMG// User SH executes this code: //IMG// The program must terminate with a user-defined message and no rows displayed if more than one product's price is 1000. With which option must “---placeholder” be replaced?

A.
B.
C.
D.
E.

Explanation

I think C is wrong because that second dbms_output.put_line will execute and will constitute 'a row displayed'.

Reference: examtopics_top_comment

Practice with progress tracking

Sign in to track wrong answers, get spaced-repetition reminders, and run timed exam mode.

Start tracked practice Pricing