سؤالين لو سمحتم

لو سمحتم اريد الأجابات الصحيحه لهذه الأسئله
1-To be callable from a SQL expression, a user-defined function must do what?

A. Be stored only in the database.
B. Have both IN and OUT parameters.
C. Use the positional notation for parameters.
D. Return a BOOLEAN or VARCHAR2 data type.

2- The creation of which database objects will cause a DDL trigger to fire? (Choose all that apply)

A. Index
B. Cluster
C. Package
D. Function
E. Synonyms
F. Dimensions
G. Database links

3- Which three are true regarding error propagation? (Choose three)

A. An exception cannot propagate across remote procedure calls.
B. An exception raised inside a declaration immediately propagates to the current block.
C. The use of the RAISE; statement in an exception handler reprises the current
exception.
D. An exception raised inside an exception handler immediately propagates to the
enclosing block