FA4 - Sheet1 Flashcards

1
Q

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

True

False

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Triggers can either be row-level or statement-level.
Group of answer choices

True

False

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

Group of answer choices

SYSTEM

DATA

APPLICATION

EVENT

A

APPLICATION

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Database triggers execute automatically whenever a data event such as _______ occurs.

Group of answer choices

DDL, TCL

DML, TCL

DML

DML, DDL

A

DML, DDL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

Group of answer choices

DATA

APPLICATION

SYSTEM

DATABASE

A

APPLICATION

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

INSERT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

STATEMENT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

INSTEAD OF

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

AFTER

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

The ________trigger is the default type of DML trigger.

A

STATEMENT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Exception section is not allowed in triggers.
Group of answer choices

True

False

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

True

False

A

t

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

True

False

A

t

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

The following determines when a DML trigger will execute: BEFORE, AFTER, INSTEAD.
Group of answer choices

True

False

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

t

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

True

False

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

True

False

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

True

False

A

t

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

True

False

A

t

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

The database event triggers are fired by non-SQL events in the database.
Group of answer choices

True

False

A

t

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

The __________ cannot be used with SHUTDOWN and STARTUP events.

Group of answer choices

ON SCHEMA

ON DATABASE

A

ON SCHEMA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

The ON SCHEMA cannot be used with ____________ events.

Group of answer choices

Shutdown and startup

Before and after

Login and logout

DML and DDL

A

Shutdown and startup

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

The ______ triggers can either be ON DATABASE or ON SCHEMA.
Group of answer choices

DML

DDL

A

DDL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

The code below will:

CREATE OR REPLACE TRIGGER log_create_trigg

AFTER CREATE ON SCHEMA

BEGIN

INSERT INTO log_table VALUES (USER, SYSDATE);

END;

Group of answer choices

Fires the trigger for DDL on all schemas in the database.

Fires the trigger only for DDL on objects in your own schema.

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

Operation is not allowed because created object is not specified.

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

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

ON DATABASE

ON SCHEMA

A

ON SCHEMA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

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

True

False

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

DBA shutting down the database is a system event.
Group of answer choices

True

False

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

A user connecting to a schema or database is a _____ event.

Group of answer choices

DATA

DATABASE

SCHEMA

SYSTEM

A

SYSTEM

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

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

Group of answer choices

CREATE ALTER TRIGGER

CREATE ALL TRIGGER

CREATE ANY TRIGGER

CREATE TRIGGER

A

CREATE ANY TRIGGER

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

What will cause an error in the given trigger declaration?

CREATE OR REPLACE TRIGGER log_salchange_trigg

AFTER UPDATE OF salary ON employees IS

DECLARE

 VDATE NUMBER := SYSDATE;

BEGIN

INSERT INTO log_table (user_id, logon_date)

VALUES (USER, VDATE); END;

Group of answer choices

IS, DECLARE

VDATE, SYSDATE

IS

DECLARE

VDATE

A

IS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

The conditional predicates are: _______, INSERTING, DELETING.

A

UPDATING

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

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

A

BEFORE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

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.

A

Conditional Predicates

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

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

A

EVENT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

TCL statement is allowed in triggers.
Group of answer choices

True

False

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

A row 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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

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

True

False

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

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

True

False

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

A statement trigger cannot SELECT from a mutating table.
Group of answer choices

True

False

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

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

True

False

A

True

42
Q

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

ON DATABASE

ON SCHEMA

A

ON DATABASE

43
Q

A ________trigger must not query or modify a mutating table.

Group of answer choices

STATEMENT-LEVEL

ROW-LEVEL

A

ROW-LEVEL

44
Q

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

Group of answer choices

CURSOR

SCHEMA TABLE

VIEW

MUTATING TABLE

A

MUTATING TABLE

45
Q

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

True

False

A

False

46
Q

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

True

False

A

True

47
Q

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

Implicitly

Explicity

A

Implicitly

48
Q

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

Group of answer choices

TRIGGER

EXCEPTION HANDLER

SUBPROGRAM

PACKAGE

A

TRIGGER

49
Q

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

Group of answer choices

DATA

SYSTEM

APPLICATION

DATABASE

A

DATABASE

50
Q

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

A

DELETE

51
Q

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

True

False

A

False

52
Q

A row trigger may SELECT from a mutating table.
Group of answer choices

True

False

A
53
Q

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

True

False

A

t

54
Q

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

True

False

A

False

55
Q

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

Group of answer choices

DO

CALL

EXECUTE

PERFORM

A

CALL

56
Q

Which trigger is applicable in the following scenario:

The DBA starts up, or shuts down, the database.

Group of answer choices

Database Trigger

DDL Trigger

Database Event Trigger

DML Trigger

A

Database Event Trigger

57
Q

All constructs declared in the package specification are automatically public constructs.
Group of answer choices

True

False

A

True

58
Q

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

True

False

A

t

59
Q

TCL are allowed in triggers.
Group of answer choices

True

False

A

False

60
Q

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

Group of answer choices

PARAMETER

ACTUAL PARAMETER

All the options

FORMAL PARAMETER

A

All the options

61
Q

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

A

DML

62
Q

DML Trigger is classified in two ways: when they execute, how they execute.
Group of answer choices

True

False

A
63
Q

The Database Event Trigger are fired by non-SQL events in the database.
Group of answer choices

True

False

A

t

64
Q

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

True

False

A

True

65
Q

The database triggers are fired by non-SQL events in the database.
Group of answer choices

True

False

A

False

66
Q

The ON SCHEMA fires the trigger only for _______ sessions.

Group of answer choices

All the options

OWN

OWN, OTHER

OTHER

A

OWN

67
Q

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

Group of answer choices

Application Trigger

Database event trigger

Event trigger

Data event trigger

A

Database event trigger

68
Q

“Public” means that the package construct (variable, procedure, function, and so on) can be seen and executed from outside the package.
Group of answer choices

True

False

A

t

69
Q

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

True

False

A

False

70
Q

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

True

False

A

t

71
Q

Which statement is used to enable a database trigger?

Group of answer choices

ALTER TABLE TRIGGER trigger_name enable

ALTER TABLE trigger_name enable

UPDATE TRIGGER trigger_name enable

ALTER TRIGGER trigger_name enable

A

ALTER TRIGGER trigger_name enable

72
Q

The conditional predicates are: _______, INSERTING, UPDATING.

A

DELETING

73
Q

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

A

ROW TRIGGER

74
Q

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

True

False

A

True

75
Q

The Conditional Predicates 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

A

True

76
Q

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

A

False

77
Q

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

True

False

A

False

78
Q

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

True

False

A
79
Q

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

True

False

A

False

80
Q

A DML trigger may have more than one triggering event.
Group of answer choices

True

False

A

t

81
Q

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

True

False

A

True

82
Q

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

True

False

A

False

83
Q

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

A

PACKAGE SPECIFICATION

84
Q

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

A

QUALIFY

85
Q

Package specification is a container that enable you to group together related PL/SQL subprograms, variables, cursors, and exceptions.
Group of answer choices

True

False

A

False

86
Q

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

True

False

A
87
Q

Which will not cause a trigger to fire?

Group of answer choices

DML operations on a view

CREATE and ALTER statement

DML operations on a table

Not in the options

A

Not in the options

88
Q

You specify a row trigger using __________clause.

A

FOR EACH ROW

89
Q

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;

Group of answer choices

True

False

A

True

90
Q

A row-level trigger must not query or modify a mutating table.
Group of answer choices

True

False

A

True

91
Q

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

DML

DDL

A

DDL

92
Q

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 recompile the specification.
Group of answer choices

True

False

A

True

93
Q

In package specification, we declare constructs that will not be visible to the calling environment.
Group of answer choices

True

False

A
94
Q

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

True

False

A
95
Q

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

True

False

A

t

96
Q

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

True

False

A

False

97
Q

Since triggers are never explicitly invoked, they cannot receive parameters.
Group of answer choices

True

False

A

True

98
Q

You can use triggers to generate derived column values _________.

Group of answer choices

AUTOMATICALLY

EXPLICITLY

IMPLICITLY

MANUALLY

A

AUTOMATICALLY

99
Q

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

True

False

A

True

100
Q

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

Group of answer choices

EVENTS

Not in the options

DML

DDL

A

DDL

101
Q

The conditional predicates are: _______, DELETING, UPDATING.

A

INSERTING