DML does not include
Answer: B) deletion of table
DML (Data Manipulation Language) is used to retrieve, insert, update, and delete data stored in database tables.
Common DML operations include:
✓ Selection: Retrieving specific records from a table.
✓ Modification (Updating): Changing existing data.
✓ Deletion of data: Removing records from a table.
However, deletion of a table is a DDL (Data Definition Language) operation, not DML. The DROP TABLE command is used to delete an entire table.
Database मा रहेको Data लाई हेर्न, नयाँ Data थप्न, पुरानो Data परिवर्तन गर्न वा हटाउन प्रयोग गरिने Language लाई DML (Data Manipulation Language) भनिन्छ।
DML का मुख्य कामहरू:
✓ Selection: Table बाट आवश्यक Data छानेर हेर्ने।
✓ Modification (UPDATE): पहिले नै राखिएको Data परिवर्तन गर्ने।
✓ Deletion (DELETE): Table भित्रका Records हटाउने।
तर पूरै Table नै हटाउने काम DML अन्तर्गत पर्दैन। त्यसका लागि DDL (Data Definition Language) को DROP TABLE Command प्रयोग गरिन्छ।
उदाहरण:
* DELETE FROM Student; → Student Table का Records हटाउँछ।
* ` DROP TABLE Student; → पूरै Student Table नै हटाउँछ।
Exam Tip: DML = Data मा परिवर्तन; DDL = Database Structure मा परिवर्तन। DROP TABLE DDL अन्तर्गत पर्छ।