← Back to exam page

1z0-149 – Oracle Database 19c: Program with PL/SQL

Loading demo links...

Showing 7–9 of 10 questions

Question 7

SERVEROUTPUT is enabled.

Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?

A)

B)

C)

D)

Select an option, then click Submit answer.

  • ○

    Option A
  • ○

    Option B
  • ○

    Option C
  • ○

    Option D
     

Question 8

Which is the correct method to implement a local subprogram in an anonymous block?

A)

B)

C)

D)

 

Select an option, then click Submit answer.

  • ○

    Option A
  • ○

    Option B
  • ○

    Option C
  • ○

    Option D
     

Question 9

Examine these statements which execute successfully:

Which anonymous block executes successfully?

A)

B)

C)

D)

 

Select an option, then click Submit answer.

  • ○

    Option A
  • ○

    Option B
  • ○

    Option C
  • ○

    Option D