FA4 - Sheet1 Flashcards
Triggers like subprograms may or may not have parameters.
Group of answer choices
True
False
False
Triggers can either be row-level or statement-level.
Group of answer choices
True
False
True
A ________ are triggers that are not part of the database.
Group of answer choices
SYSTEM
DATA
APPLICATION
EVENT
APPLICATION
Database triggers execute automatically whenever a data event such as _______ occurs.
Group of answer choices
DDL, TCL
DML, TCL
DML
DML, DDL
DML, DDL
A _______ triggers execute whenever a particular event occurs within an application.
Group of answer choices
DATA
APPLICATION
SYSTEM
DATABASE
APPLICATION
Event determines which DML operation causes the trigger to fire. Values are DELETE, UPDATE [OF column], and ______.
INSERT
The _______ trigger fires only once for each execution of the triggering statement (even if no rows are affected).
STATEMENT
The following determines when a DML trigger will execute: BEFORE, AFTER, ________.
INSTEAD OF
The ____ trigger timing executes the trigger body after the triggering DML event on a table.
AFTER
The ________trigger is the default type of DML trigger.
STATEMENT
Exception section is not allowed in triggers.
Group of answer choices
True
False
You specify a row trigger using FOR EACH ROW clause.
Group of answer choices
True
False
t
A DML trigger is a database trigger.
Group of answer choices
True
False
t
The following determines when a DML trigger will execute: BEFORE, AFTER, INSTEAD.
Group of answer choices
True
False
False
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
t
A MUTATE table is an object that is currently being modified by a DML statement.
Group of answer choices
True
False
False
The CALL is a statement is used to invoke procedure in a trigger.
Group of answer choices
True
False
True
The ON SCHEMA cannot be used with SHUTDOWN and STARTUP events.
Group of answer choices
True
False
t
DDL Triggers can either be ON DATABASE or ON SCHEMA.
Group of answer choices
True
False
t
The database event triggers are fired by non-SQL events in the database.
Group of answer choices
True
False
t
The __________ cannot be used with SHUTDOWN and STARTUP events.
Group of answer choices
ON SCHEMA
ON DATABASE
ON SCHEMA
The ON SCHEMA cannot be used with ____________ events.
Group of answer choices
Shutdown and startup
Before and after
Login and logout
DML and DDL
Shutdown and startup
The ______ triggers can either be ON DATABASE or ON SCHEMA.
Group of answer choices
DML
DDL
DDL
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.
The trigger fires whenever any type of object is created in your schema.
The ______ fires the trigger only for your own sessions.
Group of answer choices
ON DATABASE
ON SCHEMA
ON SCHEMA
The USER_TRIGGERS is used to view the detailed code and status of the trigger in data dictionary.
Group of answer choices
True
False
True
DBA shutting down the database is a system event.
Group of answer choices
True
False
True
A user connecting to a schema or database is a _____ event.
Group of answer choices
DATA
DATABASE
SCHEMA
SYSTEM
SYSTEM
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
CREATE ANY TRIGGER
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
IS
The conditional predicates are: _______, INSERTING, DELETING.
UPDATING
The ____ trigger timing executes the trigger body before the triggering DML event on a table.
BEFORE
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.
Conditional Predicates
In creating trigger you need to consider the timing and _______.
EVENT
TCL statement is allowed in triggers.
Group of answer choices
True
False
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
False
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
True
The row trigger is the default type of DML trigger.
Group of answer choices
True
False
False
The ON SCHEMA fires the trigger only for your own sessions.
Group of answer choices
True
False
True
A statement trigger cannot SELECT from a mutating table.
Group of answer choices
True
False
False