PL/SQL Advanced knowledge

What do you understand by PL/SQL Table?

• An ordered collection of the same type of elements is referred to as a PL/SQL table.

• An ordered collection of the different type of elements is referred to as a PL/SQL table.

• Position of each element in the ordered collection is determined by its index number.

• Position of each element in the unordered collection is determined by its index number.

What is the basic structure followed in PL/SQL?

• Block

• Elements

• Structural language

• None

What is a PL/SQL cursor?

• Controls context area

• Holds one or more rows

• Controls box area

• Controls everything in PLSQL

How can a name be assigned to an unnamed PL/SQL Exception Block?

• Using Pragma

• Using Name_ID

• Using specific functions

• None of the given answers

What is used whenever changes are made to a table and we need to signal other actions after the change has been made?

When does a DECLARE block have to be present?

• anonymous block

• exceptional block

• nested block

• standard PLSQL block

PL/SQL cursor is divided into 2 categories?

What are the Differences between SQL and PL/SQL?

• PL/SQL can execute multiple operations at the same time.

• PL/SQL does not directly connect with the database server.

• It can contain SQL inside it.

• It is application application-oriented language.

What are the uses of SYS.ALL_DEPENDENCIES?

• The dependencies between all the procedures, packages, triggers, and functions that the user can access.

• The dependencies between all the procedures, packages, triggers, and functions that the current user can not access.

• The dependencies between all the procedures, packages, triggers, and functions.

• The connection between all the procedures, packages, triggers, and functions.

The cursor declared in a package specification is global and can be accessed by other procedures or procedures in the package?

• TRUE

• FALSE