Question 1

To invoke package subprograms, fully ____the (public) subprogram with its PACKAGE NAME.

Accepted Answer

QUALIFY

Question 2

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

Accepted Answer

NAME

Question 3

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 4

Encapsulation refers to a  two-part structure in which the detailed package body code is invisible to the calling environment. If changes to the code are needed, the body can be edited and recompiled without having to edit or recompile the specification.

Accepted Answer

True

Question 5

Triggers like subprograms may or may not have parameters.
Group of answer choices

True

False

Accepted Answer

False

Question 6

You can use triggers to generate derived column values automatically.
Group of answer choices

True

False

Accepted Answer

True

Question 7

Since triggers are never explicitly invoked, they cannot receive ________.

 

Group of answer choices

FORMAL PARAMETER

All the options

ACTUAL PARAMETER

PARAMETER

Accepted Answer

All the options

Question 8

The_________ allow specified actions to be performed automatically within the database, without having to  write extra application code.


SUBPROGRAM

EXCEPTION HANDLER

PACKAGE

TRIGGER

Accepted Answer

TRIGGER

Question 9

DBA shutting down the database is a ______ event.

 

Group of answer choices

APPLICATION

SYSTEM

DATA

DATABASE

Accepted Answer

DATABASE

Question 10

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

Accepted Answer

EVENT

Question 11

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

Accepted Answer

BEFORE

Question 12

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

Accepted Answer

INSERT

Question 13

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

Accepted Answer

DELETE

Question 14

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

Accepted Answer

STATEMENT

Question 15

A DML trigger is a database trigger.
Group of answer choices

True

False

Accepted Answer

True

Question 16

The given trigger header below 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 17

In creating trigger you need to consider the timing and event.
Group of answer choices

True

False

Accepted Answer

True

Question 18

The row trigger is the default type of DML trigger.
Group of answer choices

True

False

Accepted Answer

False

Question 19

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

Accepted Answer

True

Question 20

The use INSTEAD OF with Database Event triggers is possible.
Group of answer choices

True

False

Accepted Answer

False

Question 21

A MUTATING table is an object that is currently being modified by a DML statement.
Group of answer choices

True

False

Accepted Answer

True

Question 22

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

Accepted Answer

True

Question 23

A MUTATE table is an object that is currently being modified by a DML statement.
Group of answer choices

True

False

Accepted Answer

False

Question 24

A MUTE table is an object that is currently being modified by a DML statement.
Group of answer choices

True

False

Accepted Answer

False

Question 25

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 26

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

Accepted Answer

ON SCHEMA

Question 27

Which trigger is applicable in the following scenario:

The DBA starts up, or shuts down, the database.

 

 

Group of answer choices

DML Trigger

Database Event Trigger

Database Trigger

DDL Trigger

Accepted Answer

Database Event Trigger

Question 28

Which DDL statements cause a DDL trigger to fire?

 

Group of answer choices

CREATE, ALTER, DROP

ALTER, DROP

CREATE, ALTER

CREATE, DROP

Accepted Answer

CREATE, ALTER, DROP

Question 29

The ______ fires the trigger only for your own sessions.
Group of answer choices

ON SCHEMA

ON DATABASE

Accepted Answer

ON SCHEMA

Question 30

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

Accepted Answer

PACKAGE BODY

Question 31

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 32

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

Accepted Answer

OR REPLACE

Question 33

The OR REPLACE option deletes an existing package body.
Group of answer choices

True

False

Accepted Answer

False

Question 34

One of the reason for using packages is encapsulation wherein related programs and variables are grouped together.
Group of answer choices

True

False

Accepted Answer

False

Question 35

To create triggers in other user’s schemas, you need the CREATE TRIGGER privilege.
Group of answer choices

True

False

Accepted Answer

False

Question 36

The USER_TRIGGERS is used to view the detailed code and status of the trigger in data dictionary.
Group of answer choices

True

False

Accepted Answer

True

Question 37

Trigger executes ________ whenever the associated action occurs.
Group of answer choices

Implicitly

Explicity

Accepted Answer

Implicitly

Question 38

A _____ trigger execute automatically whenever a data event or a system event occurs.

 

Group of answer choices

SYSTEM

APPLICATION

DATABASE

DATA

Accepted Answer

DATABASE

Question 39

A ________ are triggers that are not part of the database.

 

Group of answer choices

APPLICATION

DATA

EVENT

SYSTEM

Accepted Answer

APPLICATION

Question 40

The conditional predicates are: _______, INSERTING, DELETING.

Accepted Answer

UPDATING

Question 41

The ________trigger is the default type of DML trigger.

Accepted Answer

STATEMENT

Question 42

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 43

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

Accepted Answer

INSTEAD OF

Question 44

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

Accepted Answer

False

Question 45

A statement-level trigger fires once for each row affected by the triggering DML statement, either just BEFORE the row is processed or just AFTER.
Group of answer choices

True

False

Accepted Answer

False

Question 46

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;

Group of answer choices

True

False

Accepted Answer

True

Question 47

Event determines which DML operation causes the trigger to fire. Values are INSERT, UPDATE [OF column], and DELETE.
Group of answer choices

True

False

Accepted Answer

True

Question 48

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.
Group of answer choices

True

False

Accepted Answer

False

Question 49

A ON DATABASE fires the trigger for DDL on all schemas in the database.
Group of answer choices

True

False

Accepted Answer

False *

Question 50

You cannot create a DDL trigger that refers to a specific database object.
Group of answer choices

True

False

Accepted Answer

True

Question 51

DML Triggers can either be ON DATABASE or ON SCHEMA.
Group of answer choices

True

False

Accepted Answer

False

Question 52

DDL Triggers can either be ON DATABASE or ON SCHEMA.
Group of answer choices

True

False

Accepted Answer

True

Question 53

The ON DATABASE fires the trigger only for your own sessions.
Group of answer choices

True

False

Accepted Answer

False

Question 54

The _________ are fired by non-SQL events in the database.

 

Group of answer choices

Database event trigger

Data event trigger

Application Trigger

Event trigger

Accepted Answer

Database event trigger

Question 55

An ON DATABASE fires the trigger for ____ on all schemas in the database.

 

Group of answer choices

DDL

EVENTS

DML

Not in the options

Accepted Answer

DDL

Question 56

The ON SCHEMA cannot be used with ____________ events.

 

Group of answer choices

DML and DDL

Before and after

Login and logout

Shutdown and startup

Accepted Answer

Shutdown and startup

Question 57

A ________ fires the trigger for DDL on all schemas in the database.
Group of answer choices

ON DATABASE

ON SCHEMA

Accepted Answer

ON DATABASE

Question 58

Package construct (variable, procedure, function, and so on) that can be seen and executed  from _____ the package are considered public.

Accepted Answer

OUTSIDE

Question 59

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

Accepted Answer

PACKAGE

Question 60

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 61

Variables declared in the package body are considered private.
Group of answer choices

True

False

Accepted Answer

True

Question 62

Package body contains only subprograms that are declared in the package specification.
Group of answer choices

True

False

Accepted Answer

False

Question 63

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.
Group of answer choices

True

False

Accepted Answer

False

Question 64

Database triggers execute automatically whenever a data event such as DML or DDL occurs.
Group of answer choices

True

False

Accepted Answer

True

Database Systems FA4

CCS0029

"Know" box contains:
Time elapsed:
Retries: