Which two statements are true about database triggers? (Choose two.)

The correct answer is B. Each trigger can be of a maximum size of 32 KB. F. Both data manipulation language (DML) and data definition language (DDL) statements can. Trigger Size Restriction The size of the trigger cannot exceed 32K. When one trigger causes another trigger to fire, the triggers are said to be cascading. The database allows up to 32 triggers to cascade simultaneously. To limit the number of trigger cascades, use the…

Creating Triggers

Question

Options

AEach trigger can be of any size.
BEach trigger can be of a maximum size of 32 KB.
CA trigger can contain a maximum of 32 lines of code.
DTriggers fired by DML statements cannot cascade simultaneously.
EBoth DML and DDL statements can cascade any number of triggers,
FBoth data manipulation language (DML) and data definition language (DDL) statements can

How the community answered

(22 responses)

A
5% (1)
B
73% (16)
D
14% (3)
E
9% (2)

Explanation

Trigger Size Restriction The size of the trigger cannot exceed 32K. When one trigger causes another trigger to fire, the triggers are said to be cascading. The database allows up to 32 triggers to cascade simultaneously. To limit the number of trigger cascades, use the initialization parameter OPEN_CURSORS (described in Oracle Database

Topics

#trigger size limits#DDL triggers#DML triggers#trigger cascading

Community Discussion

No community discussion yet for this question.

Full 1Z0-144 Practice