Tag: databases

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)