Day 14 — DML (Data Manipulation Language)

What is DML in SAP HANA? Explain the commonly used DML commands.

DML (Data Manipulation Language) is used to insert, update, delete, and retrieve data from database tables. 1. What is DML? a. Used to work with table data. b. Adds new records. c. Updates existing records. d. Deletes records. e. Retrieves records. 2. Common DML Commands a. INSERT – Adds new records. b. UPDATE – Modifies existing records. c. DELETE – Removes records. d. SELECT – Retrieves data. e. MERGE – Inserts or updates data based on conditions. 3. Why Do We Use DML? a. Maintain business data. b. Update customer information. c. Retrieve reports. d. Remove unwanted records. e. Support daily business transactions.

• A customer registers on an online shopping website. • Customer details are INSERTED into the CUSTOMER table. • Later, the customer changes the mobile number. • The UPDATE command modifies the record. • If the account is deleted, the DELETE command removes the record.

1. What is DML? 2. Name five DML commands. 3. What is the purpose of INSERT? 4. What is the difference between UPDATE and DELETE? 5. Give one real-time example of DML.