GATE | GATE MOCK 2017 | Question 62
Which of the given options define a transaction correctly?
A transaction consists of DDL statements on the database schema.
A transaction consists of COMMIT or ROLLBACK in a database session.
A transaction consists of either a collection of DML statements or a DDL or DCL or TCL statement to form a logical unit of work in a database session.
A transaction consists of collection of DML and DDL statements in different sessions of the database.
Answer: (C) Explanation:
A database transaction consists of one or more DML statements to constitute one consistent change in data, or a DDL statement or a DCL command (GRANT or REVOKE). It starts with the first DML statement and ends with a DCL or DDL or TCL (COMMIT or ROLLBACK) command. Note that DDL and DCL commands hold auto commit feature.
Quiz of this Question
Share your thoughts in the comments
Please Login to comment...