Podcast
Questions and Answers
Which SQL command is used to modify existing records in a database table?
Which SQL command is used to modify existing records in a database table?
- SELECT
- ALTER
- CREATE
- UPDATE (correct)
What type of SQL command is used to add new records to a database table?
What type of SQL command is used to add new records to a database table?
- INSERT (correct)
- ALTER
- TRUNCATE
- DROP
Which DML command is NOT used for data manipulation in SQL?
Which DML command is NOT used for data manipulation in SQL?
- INSERT
- DELETE
- UPDATE
- CREATE (correct)
In SQL, which command can be used to remove existing records from a database table?
In SQL, which command can be used to remove existing records from a database table?
What does DML stand for in the context of SQL commands?
What does DML stand for in the context of SQL commands?
Flashcards are hidden until you start studying
Study Notes
DML Commands in SQL
- DML (Data Manipulation Language) is a type of SQL command used to manipulate data in a database.
- DML commands are used to insert, update, and delete data from a database table.
Types of DML Statements
- INSERT: adds new records to a database table.
- UPDATE: modifies existing records in a database table.
- DELETE: deletes existing records from a database table.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.