Which two statements are true about database triggers?

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

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

A.
Each trigger can be of any size.

B.
Each trigger can be of a maximum size of 32 KB.

C.
A trigger can contain a maximum of 32 lines of code.

D.
Triggers fired by DML statements cannot cascade simultaneously.

E.
Both DML and DDL statements cancascade any number of triggers,

F.
Both data manipulation language (DML) and data definition language (DDL) statements can
cascade up to 32 triggers

Explanation:
http://www.dba-oracle.com/m_trigger.htm



Leave a Reply 14

Your email address will not be published. Required fields are marked *


roman

roman

B F

http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/triggers.htm#LNPLS756

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 Reference), because a cursor opens every time a trigger fires.

fahmida

fahmida

right..thank u..

Leo Yu

Leo Yu

correct, thank you

swamy

swamy

Oracle Database allows up to 32 triggers to cascade at any one time.