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

How many types of exceptions are there?

2 / 20

The Implicit cursors are created to process the ____ statements.

TCL

DCL

DDL

DML

3 / 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

4 / 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

5 / 20

PL/SQL function must contain a _____.

Follow Statement

Return Statement

NULL Statement

GOTO Statement

6 / 20

Tables, views, schemas, or databases can be defined as ________ for events.

Planners

Triggers

Procedures

Cursors

7 / 20

IF-THEN statement executes the corresponding code whenever a TRUE condition is found. Otherwise, the condition cannot be rechecked. True or False?

True

False

8 / 20

Oracle creates ____ when SQL statements are processed.

Context Areas

Content Ids

Context Ids

Content Areas

9 / 20

"CASE statement" uses which keyword to work like an IF statement?

WHEN

INTO

10 / 20

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

True

False

11 / 20

How many types of PL/SQL Cursor are there?

12 / 20

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

Boolean

Check

String

Numeric

13 / 20

Which clause is used to open the cursor?

BEGIN

START

RESUME

OPEN

14 / 20

Which of the following pass parameters can be referenced by procedure?

OUT, INOUT

IN, INOUT

IN, OUT

None of the above

15 / 20

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

ERASE FUNCTION

REMOVE FUNCTION

DROP FUNCTION

DELETE FUNCTION

16 / 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

17 / 20

PL/SQL Procedure consists of _____.

Body and Footer

Header and Body

Header and Footer

None of the above

18 / 20

Which portion is optional in IF statements?

ELSE

THEN

All of the above

19 / 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

20 / 20

For ____ control over the context area, programmers can define explicit cursors.

Lesser

Greater

Equal

All of the above

Your score is

The average score is 33%

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.