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

PL/SQL function must contain a _____.

Follow Statement

Return Statement

NULL Statement

GOTO Statement

3 / 20

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

Planners

Triggers

Procedures

Cursors

4 / 20

Which clause is used to open the cursor?

BEGIN

START

RESUME

OPEN

5 / 20

How many types of exceptions are there?

6 / 20

In the contexts created by Oracle, a cursor represents a ____.

Table

Pointer

Function

None of the above

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

8 / 20

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

WHEN

INTO

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

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

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

True

False

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

13 / 20

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

PROBLEM_ERROR

VALUE_ERROR

INTERNAL_ERROR

PROGRAM_ERROR

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

PL/SQL Procedure consists of _____.

Body and Footer

Header and Body

Header and Footer

None of the above

16 / 20

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

ERASE FUNCTION

REMOVE FUNCTION

DROP FUNCTION

DELETE FUNCTION

17 / 20

"WHEN" condition is valid for which triggers?

Column Level Triggers

Table Level Triggers

Database Level Triggers

Row Level Triggers

18 / 20

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

RINSE

RISE

ROSE

RAISE

19 / 20

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

Cursor

Variables

Case

Loops

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

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.