Understanding Programmatic Oracle Structures: Intermediate-Level Quiz

Programmatic Oracle Structures Quiz

The purpose of this quiz is to test your knowledge in key areas related to programmatic structures within Oracle. This includes your ability to write and optimize PL/SQL code, create triggers, and utilize advanced data types. Let's get started!

1 / 20

A trigger can be created within a cursor. True or False?

True

False

2 / 20

Which of the following statement is false?

Error number is ranging from 20000 to 20999 are reserved for user defined messages

Oracle checks Uniqueness of User defined errors

Any procedure can raise a error and return an user message and error number

Raise_Application_error is used for raising an user defined error

3 / 20

The Implicit cursors are created to process the ____ statements.

TCL

DCL

DDL

DML

4 / 20

POST-BLOCK trigger is also a?

Transaction Trigger

Navigational Trigger

Key Trigger

All of the Mentioned

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

6 / 20

Which prefixes are available to Oracle triggers?

Neither :new nor :old

:new only

:old only

Both :new and :old

7 / 20

Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?

select job, sum(Sal) from Emp where comm is null group by job having sum(Sal) > 2500;

select job, sum(Sal) from Emp group by job having sum(Sal) > 2500 and comm is not null;

select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null group by job;

select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null;

8 / 20

Oracle creates ____ when SQL statements are processed.

Context Areas

Content Ids

Context Ids

Content Areas

9 / 20

What does DLL stand for?

Dynamic Load Library

Dynamic Language Library

Dynamic Link Library

None of the Mentioned

10 / 20

PL/SQL Procedure consists of _____.

Body and Footer

Header and Body

Header and Footer

None of the above

11 / 20

Which of the following is not a restriction for a table to be a relation?

The cells of the table must contain a single value

The columns must be ordered

All of the entries in any column must be of the same kind

No two rows in a table may be identical

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

What is the result of the following ‘PAN’NULL’KAJ’?

NULL

Error

PAN KAJ

PANKAJ

14 / 20

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

EXCEPTION

PROCEDURE

CURSOR

FUNCTION

15 / 20

A trigger can be used when you want something to automatically happen when some actions occur. True or False?

True

False

16 / 20

In Oracle, which of the following package procedure is UNRESTRICTED?

USER_EXIT

CALL_INPUT

CLEAR_BLOCK

EXECUTE_QUERY

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

18 / 20

The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger.

For, insert

for insert, on

On, for insert

None of the mentioned

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

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

Cursor

Variables

Case

Loops

Your score is

The average score is 0%

Programmatic Oracle structures focuses on Oracle’s procedural programming capabilities. This includes PL/SQL blocks, packages, procedures, functions, and triggers.

It also covers how these structures encapsulate logic, handle exceptions, and interact with database objects efficiently.

This quiz is designed for those developing complex applications in Oracle environments, aiming to enhance performance and maintainability.

All the best!