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

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

True

False

2 / 20

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

ERASE FUNCTION

REMOVE FUNCTION

DROP FUNCTION

DELETE FUNCTION

3 / 20

Which portion is optional in IF statements?

ELSE

THEN

All of the above

4 / 20

PL/SQL Procedure consists of _____.

Body and Footer

Header and Body

Header and Footer

None of the above

5 / 20

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

Main Program

Main Row

Main Table

Main Database

6 / 20

"WHEN" condition is valid for which triggers?

Column Level Triggers

Table Level Triggers

Database Level Triggers

Row Level Triggers

7 / 20

Which exception is raised when there is an internal problem in PL/SQL?

PROBLEM_ERROR

VALUE_ERROR

INTERNAL_ERROR

PROGRAM_ERROR

8 / 20

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

WHEN

INTO

9 / 20

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

Boolean

Check

String

Numeric

10 / 20

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

Lesser

Greater

Equal

All of the above

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

12 / 20

Oracle creates ____ when SQL statements are processed.

Context Areas

Content Ids

Context Ids

Content Areas

13 / 20

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

OUT, INOUT

IN, INOUT

IN, OUT

None of the above

14 / 20

Which clause is used to open the cursor?

BEGIN

START

RESUME

OPEN

15 / 20

By using PL/SQL ____, you can repeatedly execute one or more statements over and over again.

Cursor

Variables

Case

Loops

16 / 20

The Implicit cursors are created to process the ____ statements.

TCL

DCL

DDL

DML

17 / 20

How many types of exceptions are there?

18 / 20

Which command is used in order to raise an exception explicitly?

RINSE

RISE

ROSE

RAISE

19 / 20

Which sequence is the evaluation of the CASE statement done?

TOP to BOTTOM

BOTTOM to TOP

RIGHT to LEFT

None of the above

20 / 20

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

Planners

Triggers

Procedures

Cursors

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.