Oracle Triggers And Cursors: Intermediate-Level Quiz

November 25, 2024 by Kobi Okuah

Oracle Triggers And Cursors

Welcome to the "Oracle Triggers and Cursors" quiz! This quiz will test your understanding of key concepts related to triggers, which automatically execute in response to database events, and cursors, which facilitate row-by-row data manipulation. Delve into their types, best practices, and practical applications in Oracle Database. Let’s see how well you know these essential tools for effective database management!

1 / 20

Triggers are not supported for;

Insert

Delete

Update

Views

2 / 20

The default extension for an Oracle SQL*Plus file is:

.pls

.sql

.ora

.txt

3 / 20

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

True

False

4 / 20

Cursors are stored within the database and come into action when specific conditions match. True or False?

True

False

5 / 20

In which scenario is a dynamic cursor recommended?

When you need to view and process real-time changes made to the database during the execution of cursor operations

When you want to work with a stable result set that does not change during the cursor operations

When you want to optimize the performance of your database operations by minimizing the resources needed for data retrieval

6 / 20

Triggers ________ enabled or disabled

Always

Can be

Ought to be

Cannot be

7 / 20

Can I use a trigger and a cursor together?

YES

Not sure

Sometimes

8 / 20

How many types of triggers are there?

9 / 20

The variables in the triggers are declared using

–

10 / 20

Which of the following is not an advantage of triggers?

They help keep track of all the changes within the database

They also help in maintaining the integrity constraints

They help perform the row-by-row processing and row-wise validation on each row

None of the above

11 / 20

What are the after triggers?

Triggers generated after a particular operation

These triggers run after an insert, views, update or delete on a table

These triggers run after an insert, update or delete on a table

All of the mentioned

12 / 20

Which of the following is NOT an Oracle-supported trigger?

AFTER

INSTEAD OF

BEFORE

DURING

13 / 20

Triggers are very difficult to view which makes the debugging also difficult. True or False?

True

False

14 / 20

Which of the following is not an advantage of cursors?

Cursors are faster than while loops

They help perform the row-by-row processing and row-wise validation on each row

Better concurrency control can be achieved by using cursors

They use more resources each time, which may result in a network round trip

15 / 20

Which clause is used to open the cursor?

BEGIN

START

RESUME

OPEN

16 / 20

A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.

Cursor

Function

Procedure

Trigger

17 / 20

A cursor is activated and thus created in response to any SQL statement. True or False?

True

False

18 / 20

What are the two types of cursors?

Internal and External

Stationary and Hyper

Implicit and Explicit

Temporary and Permanent

19 / 20

Which prefixes are available to Oracle triggers?

: old only

: new only

Both :new and : old

Neither :new nor : old

20 / 20

How many types of PL/SQL Cursor are there?

Your score is

The average score is 0%

Oracle triggers and cursors focuses on automating tasks and managing data within Oracle databases. They allow for controlled retrieval and processing of query results, particularly for handling multi-row queries.

This quiz is designed for intermediate-level developers and database administrators who are familiar with basic SQL and PL/SQL programming.

Best of luck!