← Back to exam page

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

Loading demo links...

Showing 1–3 of 10 questions

Question 1

The SH schema contains the PRODUCTS table with column PDT_NAME defined as VARCHAR2(10).

Which two blocks of code execute successfully when invoked by user SH? (Choose two.)

A)

B)

C)

D)

E.

 

Select all that apply, then click Submit answer.

  • ○

    Option A
  • ○

    Option B
  • ○

    Option C
  • ○

    Option D
     

  • ○



     
Question 2

Which two are true about packages? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.
  • ○

    Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.
  • ○

    Package specifications can be compiled without their bodies.
  • ○

    Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.
  • ○

    A package definition must have a specification and body.
Question 3

Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Function based indexes remain usable when replacing the function on which the index depends.
  • ○

    Object privileges to execute a replaced function must be regranted to those users who had the privilege.
  • ○

    This clause can be used only for procedures and functions.
  • ○

    A function definition can be modified without dropping and re-creating it.
  • ○

    Object privileges to execute a replaced function are retained by those users who had the privileges.