Match the following : List – I vs List – II a. DCL — i. LOCK TABLE b. DML —…
2014
Match the following :
List – I vs List – II
a. DCL — i. LOCK TABLE
b. DML — ii. COMMIT
c. TCL — iii. Natural Difference
d. BINARY Operation — iv. REVOKE
Codes :
- A.
a-ii; b-i; c-iii; d-iv
- B.
a-i; b-ii; c-iv; d-iii
- C.
a-ii; b-iii; c-i; d-iv
- D.
a-iv; b-i; c-ii; d-iii
Attempted by 969 students.
Show answer & explanation
Correct answer: D
Correct matching and explanation:
- Data Control Language (DCL) -> REVOKE, because REVOKE removes permissions/privileges.
- Data Manipulation Language (DML) -> LOCK TABLE, which is associated with controlling access during data manipulation/concurrency.
- Transaction Control Language (TCL) -> COMMIT, which saves a transaction permanently.
- Binary Operation -> Natural Difference, which is a binary operation in relational algebra.
Therefore, the correct code sequence is a-iv; b-i; c-ii; d-iii. Hence, option D is correct.