← Back to exam page

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

Loading demo links...

Showing 4–6 of 10 questions

Question 4

Which two statements are true about the continue statement? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    The PL/SQL block execution terminates immediately.
  • ○

    The CONTINUE statement cannot appear outside a loop.
  • ○

    The loop completes immediately and control passes to the statement after end loop.
  • ○

    The statements after the continue statement in the iteration are executed before terminating the LOOP.
  • ○

    The current iteration of the loop completes immediately and control passes to the next iteration of the loop.
Question 5

Which two statements are true about the usage of the cursor for loops? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    The cursor needs to be closed after the iteration is complete.
  • ○

    The implicit open, fetch, exit, and close of the cursor happen.
  • ○

    The record type must be explicitly declared to control the loop.
  • ○

    The PL/SQL creates a record variable with the fields corresponding to the columns of the cursor result set.
Question 6

Examine the following command:

SQL>ALTER SESSION

SET plsql_warnings *

'enable: severe',

'enable: performance', 'ERROR: 05003';

What is the implication of the above command?

Select an option, then click Submit answer.

  • ○

    It issues a warning whenever ERROR: 05003 occur during compilation.
  • ○

    It causes the compilation to fail whenever the warning ERROR.05003 occurs.
  • ○

    It issues warnings whenever the code causes an unexpected action or wrong results performance problems.
  • ○

    It causes the compilation to fail whenever the code gives wrong results or contains statements that are never executed.