Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

3 TSY 23-24 > Database SA3 > Flashcards

Database SA3 Flashcards

1
Q

Triggers like subprograms may or may not have parameters.

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.

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.

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.

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.

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.

A

False

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.

A

True

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

A DML trigger is a database trigger.

A

True

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.

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

True

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.

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.

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.

A

True

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.

A

True

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.

A

True

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.

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.

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.

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;

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.

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.

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.

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.

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.

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;

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 may be 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.

A

False

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.

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.

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.

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.

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.

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.

A

True

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

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

A

ON DATABASE

43
Q

A ________trigger must not query or modify a mutating table.

A

ROW-LEVEL

44
Q

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

A

MUTATING TABLE

45
Q

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

A

False

46
Q

You can use triggers to generate derived column values automatically.

A

True

47
Q

Trigger executes ________ whenever the associated action occurs.

A

Implicitly

48
Q

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

A

TRIGGER

49
Q

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

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.

A

False

52
Q

A row trigger may SELECT from a mutating table.

A

False

53
Q

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

A

True

54
Q

The use INSTEAD OF with Database Event triggers is possible.

A

False

55
Q

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

A

CALL

56
Q

Which trigger is applicable in the following scenario:

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

A

Database Event Trigger

57
Q

All constructs declared in the package specification are automatically public constructs.

A

True

58
Q

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

A

True

59
Q

TCL are allowed in triggers.

A

False

60
Q

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

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.

A

False

63
Q

The Database Event Trigger are fired by non-SQL events in the database.

A

True

64
Q

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

A

True

65
Q

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

A

False

66
Q

The ON SCHEMA fires the trigger only for _______ sessions.

A

OWN

67
Q

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

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.

A

True

69
Q

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

A

False

70
Q

Database triggers execute automatically whenever a data event such as DML or DDL occurs.

A

True

71
Q

Which statement is used to enable a database trigger?

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.

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 may be used in the trigger body instead of UPDATE, INSERT, DELETE.

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 may be used in the trigger body instead of UPDATE, INSERT, DELETE.

A

False

77
Q

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

A

False

78
Q

DML Triggers can either be ON DATABASE or ON SCHEMA.

A

False

79
Q

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

A

False

80
Q

A DML trigger may have more than one triggering event.

A

True

81
Q

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

A

True

82
Q

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

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 enables you to group together related PL/SQL subprograms, variables, cursors, and exceptions.

A

False

86
Q

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

A

False

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.

A

True

91
Q

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

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.

A

True

93
Q

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

A

False

94
Q

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

A

False

95
Q

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

A

True

96
Q

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

A

False

97
Q

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

A

True

98
Q

You can use triggers to generate derived column values _________.

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.

A

True

100
Q

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

A

DDL

101
Q

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

A

True

102
Q

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

A

DDL

103
Q

The conditional predicates are: _______, DELETING, UPDATING.

A

INSERTING

3 TSY 23-24 (19 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions