Oracle Database 12c R2: Program with PL/SQL Ed 2 Quiz Questions and Answers

There are three types of loops: basic, FOR, and WHILE.

Answer :
  • True

To get the server output result and display it into the screen, you need to write -

Answer :
  • set serveroutput on

Which of the following is not true about the PL/SQL data structure VARRAY?

Answer :
  • The elements can of various data types.

Which Exception is also known as Oracle named exception handler?

Answer :
  • Predefined Exception

WRAP command is used to encrypt a PL/SQL application.

Answer :
  • TRUE

PL/SQL packages are schema objects that group logically related PL/SQL types, variables and subprograms.

Answer :
  • TRUE

Which parameter acts like a constant inside the subprogram?

Answer :
  • IN

Which of the following is used to define code that is executed / fired when certain actions or event occur?

Answer :
  • Trigger

How many attributes does every explicit cursor and cursor variable have?

Answer :
  • 4

Collection is an ordered group of elements, all of the same type.

Answer :
  • TRUE