Oracle Database: Program with PL/SQL Quiz Questions and Answers

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

Answer :
  • The CONTINUE statement cannot appear outside a loop.
  • The current iteration of the loop completes immediately and control passes to the next iteration of the loop.

Explanation :

The CONTINUE statement cannot appear outside a loop.

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

Answer :
  • 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

Explanation :

function always return value

PL/SQL Server Pages (PSPs) enable you to develop Web pages with dynamic content.

Answer :
  • TRUE

Select invalid variable types.

Answer :
  • VARCHAR1

What command can you use to see the errors from a recently created view or stored procedure?

Answer :
  • SHOW ERRORS;

PL/SQL provides many powerful functions to help you manipulate data. These built-in functions fall into which of these following categories?

Answer :
  • All mentioned above

 What is the maximum number of handlers processed before the PL/SQL block is exited when an exception occurs?

Answer :
  • Only one

When modifying procedure code, the procedure must be re-executed to validate and store it in the database. True or False? 

Answer :
  • TRUE

Which of the following can be used as an argument for a procedure parameter? 

Answer :
  • A) The name of a variable.
    B) A literal value.
    C) An expression.
    All of the above.