Question 1

Each ________ is consists of a WHEN clause, which specifies an  exception name.

Accepted Answer

EXCEPTION HANDLER

Question 2

You can use the RAISE_APPLICATION_ERROR procedure to return user-defined error messages from stored subprograms.

Accepted Answer

True

Question 3

There are 2 parameters needed in the pragma declaration of an exception.

Accepted Answer

True

Question 4

The NO_DATA_FOUND is a _______ exception.

Accepted Answer

PREDEFINED

Question 5

The %ROWTYPE can be used to declare a record based on another record.

Accepted Answer

True

Question 6

What is missing in line 3?

Accepted Answer

Nothing is missing

Question 7

The block below will display the country name and the area of each country in a chosen region. The region_id should be passed to the cursor as a parameter. The block is tested using region 5 (South America).

Accepted Answer

1

Question 8

What is missing in the given construct in order to remove an entire package? 

DROP ________ PACKAGE_NAME;

Accepted Answer

PACKAGE

Question 9

The following determines when a DML trigger will execute: BEFORE, AFTER, ________.

Accepted Answer

INSTEAD OF

Question 10

The ____ trigger timing executes the trigger body before the triggering DML event on a table.

Accepted Answer

BEFORE

Question 11

The conditional predicates are: _______, DELETING, UPDATING.

Accepted Answer

INSERTING

Question 12

A ________ fires once for each row affected by the triggering DML statement, either just BEFORE the row is processed or just AFTER.

Accepted Answer

ROW TRIGGER

Question 13

The ________trigger is the default type of DML trigger.

Accepted Answer

STATEMENT

Question 14

A DML trigger may have more than one triggering event.

Accepted Answer

TRUE

Question 15

The PREDICATE keywords are automatically declared Boolean variables which are set to TRUE or FALSE by the Oracle server. These keywords maybe used in the trigger body instead of UPDATE, INSERT, DELETE.

Accepted Answer

TRUE

Question 16

Which DDL statements cause a DDL trigger to fire?

Accepted Answer

CREATE, ALTER, DROP

Question 17

The ________ declared in the package specification are initialized  to null by default.

Accepted Answer

VARIABLES

Question 18

The package body contains the executable code of the _________ which were declared in the package specification.  It may also contain its own variable declarations.

Accepted Answer

SUBPROGRAMS

Question 19

The implementation (i.e., the detailed code) of a  procedure or function that is declared in a ________ is done in the package body.

Accepted Answer

PACKAGE SPECIFICATION

Question 20

TCL statement is allowed in triggers.

Accepted Answer

FALSE

Question 21

A DML trigger is a trigger that is automatically fired (executed) whenever an SQL DML statement (INSERT, UPDATE, or DELETE) is executed.

Accepted Answer

TRUE

Question 22

The EXECUTE is a statement is used to invoke procedure in a trigger.

Accepted Answer

FALSE

Question 23

A MUTATE table is an object that is currently being modified by a DML statement.

Accepted Answer

FALSE

Question 24

A ON DATABASE fires the trigger for DDL on all schemas in the database.

Accepted Answer

TRUE

Question 25

The ON SCHEMA cannot be used with ____________ events.

Accepted Answer

Shutdown and startup

Question 26

The __________ cannot be used with SHUTDOWN and STARTUP events.

Accepted Answer

ON SCHEMA

Question 27

A ________ fires the trigger for DDL on all schemas in the database.

Accepted Answer

ON DATABASE

Question 28

Every subprogram declared in the package specification must also be included in the _____.

Accepted Answer

PACKAGE BODY

Question 29

Package body contains only subprograms that are declared in the package specification.

Accepted Answer

FALSE

Question 30

The trigger body is written similar to anonymous block.

Accepted Answer

TRUE

Question 31

A _____ trigger execute automatically whenever a data event or a system event occurs.

Accepted Answer

SYSTEM

Question 32

The ____ trigger timing executes the trigger body after the triggering DML event on a table.

Accepted Answer

AFTER

Question 33

The _______ trigger fires only once for each execution of the triggering statement (even if no rows are affected).

Accepted Answer

STATEMENT

Question 34

A DML trigger may have more than one triggering event.

Accepted Answer

TRUE

Question 35

A DML trigger is a trigger that is automatically fired (executed) whenever an SQL DML statement (INSERT, UPDATE, or DELETE) is executed.

Accepted Answer

TRUE

Question 36

The ON SCHEMA fires the trigger only for your own sessions.

Accepted Answer

TRUE

Question 37

A row-level trigger must not query or modify a mutating table.

Accepted Answer

TRUE

Question 38

The ON SCHEMA cannot be used with SHUTDOWN and STARTUP events.

Accepted Answer

TRUE

Question 39

A ________trigger must not query or modify a mutating table.

Accepted Answer

ROW-LEVEL

Question 40

A ________ table is an object that is currently being modified by a DML statement.

Accepted Answer

MUTATING TABLE

Question 41

The _________ are fired by non-SQL events in the database.

Accepted Answer

Database Event Trigger

Question 42

The _____ is the interface to your applications that declares the constructs (procedures, functions, variables, and so on) which are visible to the calling environment.

Accepted Answer

PACKAGE SPECIFICATION

Question 43

The implementation (i.e., the detailed code) of a  procedure or function that is declared in a ________ is done in the package body.

Accepted Answer

PACKAGE SPECIFICATION

Question 44

Triggers can either be column-level or statement-level.

Accepted Answer

FALSE

Question 45

A ________ are triggers that are not part of the database.

Accepted Answer

APPLICATION

Question 46

DBA shutting down the database is a ______ event.

Accepted Answer

SYSTEM

Question 47

In creating trigger you need to consider the timing and _______.

Accepted Answer

EVENT

Question 48

DML Trigger is classified in two ways: when they execute, how they execute.

Accepted Answer

FALSE

Question 49

In creating trigger you need to consider the timing and event.

Accepted Answer

TRUE

Question 50

You specify a row trigger using FOR EACH ROW clause.

Accepted Answer

TRUE

Question 51

The ______ triggers can either be ON DATABASE or ON SCHEMA.

Accepted Answer

DDL

Question 52

The _______ is a statement is used to invoke procedure in a trigger.

Accepted Answer

CALL

Question 53

The OR REPLACE options _______ and re-creates the package specification.

Accepted Answer

DROPS

Question 54

The package specification is the interface to your applications that declares the constructs (procedures, functions, variables, and so on) which are visible to the calling environment.

Accepted Answer

TRUE

Question 55

One of the reason for using packages is encapsulation wherein related programs and variables are grouped together.

Accepted Answer

FALSE

Question 56

DBA shutting down the database is a system event.

Accepted Answer

TRUE

Question 57

To create triggers in other user’s schemas, you need to the __________ privilege.

Accepted Answer

ANY TRIGGER

Question 58

Which will view the detailed code and status of the trigger in data dictionary?

Accepted Answer

USER_TRIGGERS

Question 59

The following determines when a DML trigger will execute: BEFORE, AFTER, INSTEAD.

Accepted Answer

FALSE

Question 60

Inheritance refers to a  two-part structure in which the detailed package body code is invisible to the calling environment, which can only see the. If changes to the code are needed, the bod

Accepted Answer

FALSE

Question 61

Triggers can either be row-level or statement-level.

Accepted Answer

TRUE

Question 62

Which will not cause a trigger to fire?

Accepted Answer

Not in the options

Question 63

Trigger executes ________ whenever the associated action occurs.

Accepted Answer

Implicitly

Question 64

Event determines which DML operation causes the trigger to fire. Values are INSERT, UPDATE [OF column], and ______.

Accepted Answer

DELETE

"Know" box contains:
Time elapsed:
Retries:

Question

Question

Question

Database