SQL DML Commands Quiz

Which of the following is a DML command?

• CREATE

• ALTER

• INSERT

• DROP

Which SQL command is used to modify existing records in a table?

• INSERT

• UPDATE

• DELETE

• SELECT

Which clause is used in conjunction with DML commands to filter records?

• ORDER BY

• WHERE

• GROUP BY

• HAVING

Which DML statement is used to remove records from a table?

• DELETE

• TRUNCATE

• DROP

• REMOVE

What will the following SQL statement do? INSERT INTO Students (ID, Name) VALUES (101, 'John');

• Delete the student with ID 101

• Insert a new student record with ID 101 and Name 'John'

• Update the student name to 'John' where ID is 101

• Create a new table called Students

Which SQL statement is used to retrieve data from a database?

• SELECT

• UPDATE

• INSERT

• DELETE

Which of the following is true about the DELETE statement?

• It removes the table structure from the database

• It removes specific records based on a condition

• It permanently removes all records without a condition

• It cannot be rolled back

What happens if the WHERE clause is omitted in an UPDATE statement?

• Only the first row is updated

• An error occurs

• All rows in the table are updated

• No rows are updated

Which of the following commands is used to add new data into a table?

• ADD

• UPDATE

• INSERT

• ALTER

Which of the following DML statements can be rolled back in SQL?

• INSERT

• UPDATE

• DELETE

• All of the above