Question:medium
Which of the following is a DML command in SQL?
Which of the following is a DML command in SQL?
Show Hint
Remember — DML changes the data,
DDL changes the structure.
DDL changes the structure.
Updated On: Jan 14, 2026
- UPDATE
- CREATE
- ALTER
- DROP
Show Solution
The Correct Option is A
Solution and Explanation
SQL commands are primarily classified into DML, DDL, and DCL. DML (Data Manipulation Language) encompasses commands that alter data, such as INSERT, UPDATE, DELETE, and SELECT. UPDATE, a quintessential DML command, is employed to modify existing records within a table. CREATE and ALTER fall under DDL (Data Definition Language) commands, which are used to define or modify database structures like tables. DROP is another DDL command utilized for deleting tables or databases. Consequently, UPDATE is the sole DML command present in this context.
Was this answer helpful?
0
Top Questions on SQL
- Given table 'StudAtt' with structure as (Rno, Attdate, Attendance). Identify the suitable command to add a primary key to the table after creation.
Note: We want to make both Rno and Attdate columns as primary key. Given the following table:
ENO SALARY A101 4000 B109 NULL C508 6000 A305 2000 State the output of the following query:
SELECT COUNT(SALARY) FROM EMPLOYEE;
- ____________________________________ is used to search for a specific pattern in a column.
- The SELECT command when combined with DISTINCT clause is used to:
- Want to practice more? Try solving extra ecology questions todayView All Questions
