Trigger type

Trigger body

Trigger event

Trigger timing

I am in Others Exception

I am in no data found Exception

Compilation Error

None of the above

Positional & Named

Positional alone

Positional ,Name and Combination

None of the above

%OPEN

%ISOPEN

1 & 2

None of the above

%ROWTYPE allows you to associate a variable with an entire table row

%ROWTYPE associates a variable with a single column type

Both of the above

None of the above

1

Null

Error

None of the above

900

1000

1100

1050

SQL%ROWCOUNT, SQL%ISFOUND,SQL%NOTFOUND,SQL%ISOPEN

SQL%ROWCOUNT, SQL%FOUND,SQL%NOTFOUND,SQL%OPEN

SQL%ROWCOUNT, SQL%FOUND,SQL%NOTFOUND,SQL%ISOPEN

All of the above

binary

Character

ASCII

All of the above

True

False

CLOB

BLOB

LONG

All of the above

DELCARE and BEGIN

DECALRE and EXCEPTION

EXCEPTION and END

BEGIN and END

To duplicate the functionality of other triggers.

To replicate built-in constraints in the Oracle server such as primary key and foreign key.

To guarantee that when a specific operation is performed, related actions are performed.

For centralized, global operations that should be fired for the triggering statement, regardless of which user or application issues the statement.

+

(

]

/

SELECT column_name ALIAS alias_name FROM table_name;

SELECT column_name alias_name FROM table_name;

SELECT alias_name FROM table_name;

ASSIGN alias_name TO column_name;

Insert some records, COMMIT, ROLLBACK

SAVEPOINT, insert some records, ROLLBACK, ROLLBACK, COMMIT

ROLLBACK, insert some records, COMMIT

ROLLBACK, insert some records, COMMIT, COMMIT

?, *

_, %

?, _

*, %

ROUND(4.5, 0) < TRUNC(4.5, 0)

ROUND(4.1, 0) < TRUNC(4.2, 0

ROUND(8.9, 0) > TRUNC(8.9, 0)

ROUND(8.9, 1) > TRUNC(8.95, 2)

True

False

True

False