Tag: databases
Questions Related to databases
-
binary
-
Character
-
ASCII
-
All of the above
-
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)