Open In App

GATE | GATE MOCK 2017 | Question 62

Like Article
Like
Save
Share
Report

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:

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


Last Updated : 28 Jun, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads