PL/SQL True and False

Question 1

PL/SQL is a procedural language extension to SQL.
- True
- False

Answer 1

True

Question 2

An implicit cursor is automatically created by Oracle when an SQL statement is executed in PL/SQL.

- True
- False

Answer 2

True

Question 3

The %ROWTYPE attribute is used to declare a variable that can hold an entire row of data selected from a table.

- True
- False

Answer 3

True

Question 4

The RAISE_APPLICATION_ERROR procedure is used to create custom error messages in PL/SQL.

- True
- False

Answer 4

True

Question 5

PL/SQL allows the use of nested blocks.

- True
- False

Answer 5

True