1Z0-149 Exam Question 1

Examine these statements:

Which two are true? (Choose two.)
  • 1Z0-149 Exam Question 2

    Examine this table in the SH schema:

    User SH executes this code:

    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?
  • 1Z0-149 Exam Question 3

    SERVEROUTPUT is enabled.
    Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?
  • 1Z0-149 Exam Question 4

    Examine this DECLARE section:

    Which line will cause an error upon execution?
  • 1Z0-149 Exam Question 5

    Examine these statements which execute successfully:

    Which anonymous block executes successfully?