← Back to exam page

1z0-144 – Oracle Database 11g: Program with PL/SQL

Loading demo links...

Showing 1–3 of 10 questions

Question 1

Examine the following block of code:

Which two statements are correct about the code above? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    The function goes through only the parse and executes phases.
  • ○

    The function goes through the parse, bind, and execute phases.
  • ○

    The function goes through the parse, bind, execute, and fetch phases.
  • ○

    All the processing phases for the function are performed only at run time.
  • ○

    Only the EXECUTE IMMEDIATE statement inside the function is parsed at run time.
Question 2

Which two tasks should be created as functions instead of as procedures? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Reference host or bind variables in a PL/SQL block of code
  • ○

    Tasks that compute and return multiple values to the calling environment
  • ○

    Tasks that compute a value that must be returned to the calling environment
  • ○

    Tasks performed in SQL that increase data independence by processing complex data analysis within the Oracle server, rather than by retrieving the data into an application
Question 3

Which two statements are correct about PL/SQL package components? (Choose two)

Select all that apply, then click Submit answer.

  • ○

    A package must have both specification and body.
  • ○

    A package body can exist without the package specification.
  • ○

    A package specification can exist without the package body.
  • ○

    When a packaged public variable is called for the first time in a session, the entire package is loaded into memory.