Question:
Match the SQL command categories in Column A with their commands in Column B:
| Column A (Category) | Column B (Command) |
|---|---|
| 1. DDL | A. INSERT, UPDATE, DELETE |
| 2. DML | B. GRANT, REVOKE |
| 3. DCL | C. CREATE, ALTER, DROP |
कॉलम A की SQL श्रेणियों का मिलान कॉलम B के कमांड से करें:
| कॉलम A (श्रेणी) | कॉलम B (कमांड) |
|---|---|
| 1. DDL | A. INSERT, UPDATE, DELETE |
| 2. DML | B. GRANT, REVOKE |
| 3. DCL | C. CREATE, ALTER, DROP |
Options:
- 1-C, 2-A, 3-B
- 1-A, 2-C, 3-B
- 1-C, 2-B, 3-A
- 1-B, 2-A, 3-C
- 1-C, 2-A, 3-B
- 1-A, 2-C, 3-B
- 1-C, 2-B, 3-A
- 1-B, 2-A, 3-C
Correct Answer: a)
Explanation:
1. DDL (Data Definition Language) includes CREATE, ALTER, DROP (C).
2. DML (Data Manipulation Language) includes INSERT, UPDATE, DELETE (A).
3. DCL (Data Control Language) includes GRANT, REVOKE (B).
Hence, 1-C, 2-A, 3-B (Option a).
DDL = CREATE, ALTER, DROP (1-C); DML = INSERT, UPDATE, DELETE (2-A); DCL = GRANT, REVOKE (3-B)। सही मिलान 1-C, 2-A, 3-B है (विकल्प a)।