PrepSnap logoPrepSnap
Pass

Question

1.
2.
3.
4.
Answer (Detailed Solution Below)

Option 3 : DDL: TRUNCATE, DROP; DML: INSERT, UPDATE / DDL: TRUNCATE, DROP; DML: INSERT, UPDATE

Advertisement

Detailed Solution

सही उत्तर DDL: TRUNCATE, DROP; DML: INSERT, UPDATE / DDL: TRUNCATE, DROP; DML: INSERT, UPDATE है।

Key Points
Helpful?
PrepSnapprepsnap.in • Part -A

Question:

Which of the following pairs correctly classifies SQL commands? / निम्नलिखित में से कौन-सा युग्म SQL कमांडों का सही वर्गीकरण करता है?

1.
DDL: SELECT, INSERT / DDL: SELECT, INSERT
2.
DML: CREATE, ALTER / DML: CREATE, ALTER
3.
DDL: TRUNCATE, DROP; DML: INSERT, UPDATE / DDL: TRUNCATE, DROP; DML: INSERT, UPDATE
4.
DCL: DELETE, UPDATE / DCL: DELETE, UPDATE

Correct Answer: DDL: TRUNCATE, DROP; DML: INSERT, UPDATE / DDL: TRUNCATE, DROP; DML: INSERT, UPDATE

TRUNCATE and DROP change the structure of database objects, so they are DDL; INSERT and UPDATE manipulate data, so they are DML. SELECT is DQL/DML, CREATE and ALTER are DDL, and GRANT and REVOKE are DCL. / TRUNCATE और DROP डेटाबेस ऑब्जेक्ट्स की संरचना बदलते हैं, अतः वे DDL हैं; INSERT और UPDATE डेटा में हेरफेर करते हैं, अतः वे DML हैं। SELECT, DQL/DML है; CREATE और ALTER, DDL हैं; तथा GRANT और REVOKE, DCL हैं।

Downloaded from PrepSnap (prepsnap.in)