Oracle Advanced PL/SQL – Intermediate Level Quiz

Oracle PL/SQL Quiz

These PL/SQL Quiz questions are written for beginners as well as advanced, practice them to enhance and test the knowledge of PL/SQL.

1 / 20

The call function returns program control to the ____ after completing the defined task successfully.

Main Program

Main Row

Main Table

Main Database

2 / 20

"WHEN" condition is valid for which triggers?

Column Level Triggers

Table Level Triggers

Database Level Triggers

Row Level Triggers

3 / 20

How many types of PL/SQL Cursor are there?

4 / 20

How many types of exceptions are there?

5 / 20

The Implicit cursors are created to process the ____ statements.

TCL

DCL

DDL

DML

6 / 20

The "AS" Keyword is used in the PL/SQL function in order to create a _____?

Quadratic Function

Standalone Function

One to One Function

Identity Function

7 / 20

It is called ____ when the subprogram calls itself and ____ is the process.

Recursive Call, Recursive Name

Recursive Name, Recursive Call

Recursion, Recursive Call

Recursive Call, Recursion

8 / 20

Table-level triggers do not have access to OLD and NEW references. True or False?

True

False

9 / 20

Which of the following is the correct syntax of the IF statement?

IF-THEN-ELSE statement

IF-THEN-ELSIF statement

IF-THEN statement

All of the above

10 / 20

Which sequence is the evaluation of the CASE statement done?

TOP to BOTTOM

BOTTOM to TOP

RIGHT to LEFT

None of the above

11 / 20

PL/SQL function must contain a _____.

Follow Statement

Return Statement

NULL Statement

GOTO Statement

12 / 20

PL/SQL Procedure consists of _____.

Body and Footer

Header and Body

Header and Footer

None of the above

13 / 20

Which portion is optional in IF statements?

ELSE

THEN

All of the above

14 / 20

Which of the following is not an advantage of trigger?

Maintains the integrity of referential

Tables are replicated asynchronously

Various column values are automatically generated by triggers

Validating transactions and preventing them from being invalid

15 / 20

Errors that are encountered during the execution of the program are referred to as ____ in PL/SQL.

EXCEPTION

PROCEDURE

CURSOR

FUNCTION

16 / 20

Which of the following is NOT a type of PL/SQL literal?

Boolean

Check

String

Numeric

17 / 20

Which clause is used to open the cursor?

BEGIN

START

RESUME

OPEN

18 / 20

Which function is used to remove the PL/SQL function?

ERASE FUNCTION

REMOVE FUNCTION

DROP FUNCTION

DELETE FUNCTION

19 / 20

Calling a function requires that the parameters be provided along with the ____, and if the function returns a value, that value can be stored.

Optional Parameter List

Rollback Statement

IF Statement

Function Name

20 / 20

Which of the following clauses does not come in the syntax while raising an exception?

END

WHEN

DECLARE

Your score is

The average score is 37%

Oracle Advanced PL/SQL focuses on advanced programming techniques in PL/SQL. This includes performance optimization, dynamic SQL, collections, triggers, and packages.

It also includes the best practices for error handling, bulk processing, and integrating PL/SQL with other Oracle database features.

This quiz is ideal for those looking to deepen their expertise in advanced PL/SQL programming techniques and optimize database performance.