PL/SQL Quiz Part 2

What is PL/SQL?

• Procedural Language/Structured Query Language

• Programming Language for SQL

• Pure Language/SQL

• None of the above

Which of the following is a valid PL/SQL data type?

• INTEGER

• CHAR

• BOOLEAN

• All of the above

Which of the following is a composite data type in PL/SQL?

• VARCHAR2

• BOOLEAN

• RECORD

• NUMBER

Which keyword is used to declare a constant in PL/SQL?

• STATIC

• CONSTANT

• IMMUTABLE

• READONLY

PL/SQL supports exception handling. Which of the following is an example of a predefined exception?

• NO_DATA_FOUND

• VALUE_ERROR

• TOO_MANY_ROWS

• All of the above

In which section do we declare variables in a PL/SQL block?

• BEGIN

• DECLARE

• EXCEPTION

• END

Which of the following statements is used to exit a loop in PL/SQL?

• EXIT

• BREAK

• CONTINUE

• RETURN

Which of the following is true about PL/SQL blocks?

• A block must have an exception section.

• A block must have a begin-end section.

• A block must always have a declare section.

• A block cannot contain nested blocks.

What is the default value of a PL/SQL variable that is declared but not initialized?

• NULL

• 0

• Undefined

• Empty String

Which keyword is used to handle exceptions in PL/SQL?

• EXCEPTION

• CATCH

• TRY

• WHEN