-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
What is the type of TRUNCATE statement, whether it is a DDL or DML type ?
I have read somewhere as DDL statement as it has implicit commit statement.
-
-
What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?
A cursor declared in a package specification is global and can be accessed by other procedures or procedures in a package.A cursor declared in a procedure is local to the procedure that can not be accessed by other procedures.
-
What does COMMIT do ?
COMMIT makes permanent the changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that start only after transaction is committed.
-
Define Transaction ?
A Transaction is a logical unit of work that comprises one or more SQL statements executed by a single user.