Question 1

What is missing in the given package body construct?

CREATE [OR REPLACE] PACKAGE package_name

IS|AS

private type and variable declarations  subprogram bodies

[BEGIN initialization statements]

END [package_name];

Accepted Answer

BODY

Question 2

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 3

The ____ option drops and  re-creates the package specification.

Accepted Answer

CREATE OR REPLAC

Question 4

The OR REPLACE option deletes an existing package body.

Accepted Answer

False

Question 5

Encapsulation 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 body can be edited and recompiled without having to edit or recom

Accepted Answer

True

Question 6

One of the differences between triggers and stored procedure is that, TCL statements are allowed in triggers which are not allowed in the stored procedures.

Accepted Answer

False

Question 7

Triggers like subprograms may or may not have parameters.

Accepted Answer

False

Question 8

Which will view the detailed code and status of the trigger in data dictionary?

 

Group of answer choices

USER_TRIGGERS

All the options

USER_OBJECTS

USER_ERRORS

Accepted Answer

All the options

Question 9

The_________ allow specified actions to be performed automatically within the database, without having to  write extra application code.

Accepted Answer

TRIGGER

Question 10

A _______ triggers execute whenever a particular event occurs within an application.

Accepted Answer

APPLICATION

Question 11

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

Accepted Answer

DML

Question 12

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

Accepted Answer

INSTEAD OF

Question 13

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‑LEVEL TRIGGER

Question 14

The ________ 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

CONDITIONAL PREDICATES

Question 15

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

Accepted Answer

DELETE

Question 16

Exception section is not allowed in triggers.

Accepted Answer

False

Question 17

A DML trigger is a database trigger.

Accepted Answer

True

Question 18

TCL statement is allowed in triggers.
Group of answer choices

True

False

Accepted Answer

False

Question 19

You specify a row trigger using FOR EACH ROW clause.
Group of answer choices

True

False

Accepted Answer

True

Question 20

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

Accepted Answer

True

Question 21

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

Accepted Answer

False

Question 22

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

Accepted Answer

True

Question 23

The EXECUTE is a statement is used to invoke procedure in a trigger.
Group of answer choices

True

False

Accepted Answer

False

Question 24

The ON SCHEMA cannot be used with SHUTDOWN and STARTUP events.
Group of answer choices

True

False

Accepted Answer

True

Question 25

The CALL is a statement is used to invoke procedure in a trigger.
Group of answer choices

True

False

Accepted Answer

True

Question 26

The code below will:

 

CREATE OR REPLACE TRIGGER log_create_trigg 

AFTER CREATE ON SCHEMA

BEGIN

INSERT INTO log_table  VALUES (USER, SYSDATE);

END;

Accepted Answer

The trigger fires whenever any type of object is created in your schema.

Question 27

An ON DATABASE fires the trigger for ____ on all schemas in the database.

Accepted Answer

DDL

Question 28

A ________trigger must not query or modify a mutating table.

Accepted Answer

ROW-LEVEL

Question 29

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

Accepted Answer

ON DATABASE

Question 30

The ______ fires the trigger only for your own sessions.

Accepted Answer

ON SCHEMA

Question 31

The package  specification should contain the subprogram ________ and  associated parameters terminated by a semicolon.

Accepted Answer

NAME

Question 32

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

Accepted Answer

PACKAGE BODY

Question 33

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

Accepted Answer

VARIABLES

Question 34

Variables declared in the package body are considered private.

Accepted Answer

True

Question 35

A package is considered as a database Object.

Accepted Answer

True

Question 36

To create triggers in other user’s schemas, you need the CREATE TRIGGER privilege.

Accepted Answer

False

Question 37

Since triggers are never explicitly invoked, they cannot receive parameters.

Accepted Answer

True

Question 38

Since triggers are never explicitly invoked, they cannot receive ________.

Accepted Answer

actual parameters

Question 39

You can use triggers to generate derived column values _________.

Accepted Answer

AUTOMATICALLY

Question 40

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

Accepted Answer

BEFORE

Question 41

The conditional predicates are: _______, INSERTING, DELETING.

Accepted Answer

UPDATING

Question 42

The row trigger is the default type of DML trigger.

Accepted Answer

False

Question 43

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

Accepted Answer

True

Question 44

A DML trigger may have more than one triggering event.

Accepted Answer

True

Question 45

The given trigger header contains no error.

CREATE  OR  REPLACE  TRIGGER  emp_del_trigg AFTER  DELETE  ON  employees

BEGIN  <assume valid PL/SQL statements here> END;

Accepted Answer

True

Question 46

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

Accepted Answer

True

Question 47

You cannot create a DDL trigger that refers to a specific database object.

Accepted Answer

True

Question 48

A statement trigger cannot SELECT from a mutating table.

Accepted Answer

False

Question 49

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

Accepted Answer

True

Question 50

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

Accepted Answer

Database event trigger

Question 51

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

Accepted Answer

CALL

Question 52

The ON SCHEMA fires the trigger only for _______ sessions.

Accepted Answer

OWN

"Know" box contains:
Time elapsed:
Retries:

DBSA FA4