← Back to exam page

1z0-148 – Oracle Database 12c: Advanced PL/SQL

Loading demo links...

Showing 4–6 of 10 questions

Question 4

Which two statements are correct for collecting data about identifiers in PL/SQL source code?

Select all that apply, then click Submit answer.

  • ○

    CREATE < function/Procedure> PLSCOPE_SETTINGS = ‘IDENTIFIERS: ALL’ AS …
  • ○

    ALTER SYSTEM SET PLSCOPE_SETTINGS = ‘IDENTIFIERS: NONE’
  • ○

    ALTER SESSION SET PLSCOPE_SETTINGS = ‘IDENTIFIERS: NONE’
  • ○

    ALTER SESSION SET PLSCOPE_SETTINGS = ‘IDENTIFIERS: ALL’
  • ○

    ALTER COMPILE PLSCOPE_SETTINGS = ‘IDENTIFIERS: ALL’
Question 5

Examine this block:

Which two will be correct after line 5?

Select all that apply, then click Submit answer.

  • ○

    va. LAST and va. LIMIT will return the same value.
  • ○

    va. LAST and va. COUNT will return the same value.
  • ○

    va. LIMIT and va. COUNT will return the same value.
  • ○

    va. LIMIT and va. NEXT (199) will return the same value.
  • ○

    va. LAST will return 200.
  • ○

    va. NEXT (199) will return NULL.
Question 6

Examine this PL/SQL function:

What happens when the function is created with PLSQL_WARNINGS set to ‘ENABLE: ALL’?

Select an option, then click Submit answer.

  • ○

    There are no compilation warnings or errors.
  • ○

    It fails compilation.
  • ○

    An information compilation warning is generated.
  • ○

    A performance compilation warning is generated.
  • ○

    A severe compilation warning is generated.