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

Which of the following is true about the parameter modes in PL/SQL Subprograms?

Answer :
  • All of the above.

Which of the data types are supported by plsql?

Answer :
  • All of the above

A Stored Procedure is a______.

Answer :
  • All of the above

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

PL/SQL stands for -

Answer :
  • Procedural Language/SQL

Select invalid variable types.

Answer :
  • VARCHAR1

PL/SQL Expressions are constructed using.

Answer :
  • Both A & B

PL/SQL keywords are not case-sensitive.

Answer :
  • TRUE

PL/SQL is a completely portable, high-performance transaction processing language.

Answer :
  • TRUE

Which operator tests set membership?

Answer :
  • IN Operator