FC0-U61 · Question #890
Which of the following are data manipulation SQL commands? (Select two).
The correct answer is B. UPDATE D. INSERT. Data Manipulation Language (DML) commands are used to manage data within database objects, including adding, modifying, and deleting records.
Question
Which of the following are data manipulation SQL commands? (Select two).
Options
- AALTER
- BUPDATE
- CMODIFY
- DINSERT
- EDROP
How the community answered
(30 responses)- A3% (1)
- B87% (26)
- C3% (1)
- E7% (2)
Why each option
Data Manipulation Language (DML) commands are used to manage data within database objects, including adding, modifying, and deleting records.
ALTER is a Data Definition Language (DDL) command used to change the structure of a database object, not the data itself.
The UPDATE command is a DML statement used to modify existing records in a database table.
MODIFY is not a standard SQL DML command; while some SQL dialects might have similar functions, INSERT, UPDATE, and DELETE are the core DML commands.
The INSERT command is a DML statement used to add new records (rows) into a database table.
DROP is a Data Definition Language (DDL) command used to delete entire database objects like tables or databases, not to manipulate data within them.
Concept tested: SQL Data Manipulation Language (DML) commands
Source: https://learn.microsoft.com/en-us/sql/t-sql/language-reference?view=sql-server-ver16
Topics
Community Discussion
No community discussion yet for this question.