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

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

2 / 20

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

PROBLEM_ERROR

VALUE_ERROR

INTERNAL_ERROR

PROGRAM_ERROR

3 / 20

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

True

False

4 / 20

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

OUT, INOUT

IN, INOUT

IN, OUT

None of the above

5 / 20

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

Planners

Triggers

Procedures

Cursors

6 / 20

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

RINSE

RISE

ROSE

RAISE

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

8 / 20

"WHEN" condition is valid for which triggers?

Column Level Triggers

Table Level Triggers

Database Level Triggers

Row Level Triggers

9 / 20

Which sequence is the evaluation of the CASE statement done?

TOP to BOTTOM

BOTTOM to TOP

RIGHT to LEFT

None of the above

10 / 20

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

ERASE FUNCTION

REMOVE FUNCTION

DROP FUNCTION

DELETE FUNCTION

11 / 20

Which clause is used to open the cursor?

BEGIN

START

RESUME

OPEN

12 / 20

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

Main Program

Main Row

Main Table

Main Database

13 / 20

PL/SQL Procedure consists of _____.

Body and Footer

Header and Body

Header and Footer

None of the above

14 / 20

Which portion is optional in IF statements?

ELSE

THEN

All of the above

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

16 / 20

Oracle creates ____ when SQL statements are processed.

Context Areas

Content Ids

Context Ids

Content Areas

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

18 / 20

The Implicit cursors are created to process the ____ statements.

TCL

DCL

DDL

DML

19 / 20

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

Cursor

Variables

Case

Loops

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

Your score is

The average score is 0%

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.