← Back to exam page

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

Loading demo links...

Showing 4–6 of 10 questions

Question 4

Which three are true about the procedure overloading feature? (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    Each procedure can be a nested subprogram.
  • ○

    Each procedure's formal parameters can differ in data type or name.
  • ○

    Each procedure must use named notation to specify the corresponding actual parameters.
  • ○

    Each procedure's formal parameters must differ in name.
  • ○

    Each procedure can be a packaged subprogram.
  • ○

    Each procedure must use positional notation to specify the corresponding actual parameters.
  • ○

    Each procedure can be a standalone subprogram.
Question 5

Examine this DECLARE section:

Which two lines are valid? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    line 5
  • ○

    line 6
  • ○

    line 7
  • ○

    line 4
  • ○

    line 3
  • ○

    line 2
Question 6

Examine the EMPLOYEES table structure:

Now, examine this code:

Which statement is true about the result of executing this block?

Select an option, then click Submit answer.

  • ○

    It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.
  • ○

    It will return an error at line 2.
  • ○

    It will return an error at line 3.
  • ○

    It will return an error at line 8.
  • ○

    It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.