Match the following – List – I List – II(a) DCL (i) LOCK TABLE (b) DML (ii)…
2022
Match the following –
List – I List – II
(a) DCL (i) LOCK TABLE
(b) DML (ii) COMMIT
(c) TCL (iii) Natural Difference
(d) Binary operation (iv) REVOKE
- A.
a-(ii), b-(i), c-(iii), d-(iv)
- B.
a-(i), b-(ii), c-(iv), d-(iii)
- C.
a-(iii), b-(i), c-(i), d-(iv)
- D.
a-(iv), b-(i), c-(ii), d-(iii)
Attempted by 1501 students.
Show answer & explanation
Correct answer: D
Correct Match:
(a) DCL → (iv) REVOKE
(b) DML → (i) LOCK TABLE
(c) TCL → (ii) COMMIT
(d) Binary operation → (iii) Natural Difference
Explanation:
DCL (Data Control Language): Deals with rights, permissions, and access control in a database. REVOKE is a standard DCL command.
DML (Data Manipulation Language): Involves managing and manipulating data within database tables. LOCK TABLE is associated with controlling access during data manipulation operations.
TCL (Transaction Control Language): Deals with transaction management. COMMIT is used to permanently save a transaction.
Binary Operation: In relational algebra, a binary operation requires two relations as input. Natural Difference (Difference) operates on two relations, making it a binary operation.