Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

GATE | GATE MOCK 2017 | Question 62

  • Last Updated : 28 Jun, 2021

Which of the given options define a transaction correctly?
(A) A transaction consists of DDL statements on the database schema.
(B) A transaction consists of COMMIT or ROLLBACK in a database session.
(C) 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.
(D) A transaction consists of collection of DML and DDL statements in different sessions of the database.


Answer: (C)

Explanation:

Attention reader! Don’t stop learning now.  Practice GATE exam well before the actual exam with the subject-wise and overall quizzes available in GATE Test Series Course.

Learn all GATE CS concepts with Free Live Classes on our youtube channel.

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

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!