SQL DML Quiz

What does the acronym DML stand for?

• Data Modeling Language

• Data Management Language

• Data Manipulation Language

• Data Markup Language

Which SQL statement is used to add new rows to a table?

• UPDATE

• DELETE

• INSERT

• CREATE

What happens if the number of columns listed in an INSERT statement does not match the number of values provided?

• The extra columns will be ignored

• The database will assign default values

• An error will occur

• The values will be filled in randomly

Which SQL statement is used to change the data within an existing row?

• ALTER

• UPDATE

• DELETE

• INSERT

In an INSERT INTO statement, which of the following is not a valid method of inserting rows?

• ALTER

• UPDATE

• DELETE

• INSERT

Which of the following allows you to remove rows from a table in SQL?

• DELETE

• UPDATE

• INSERT

• SELECT

What happens when you use the DELETE statement without a WHERE clause?

• No rows are deleted

• All rows are deleted

• Only the first row is deleted

• The command will produce an error

Which command is used to remove all data from a table without removing the table itself?

• DROP

• DELETE

• TRUNCATE

• REMOVE

In an UPDATE statement, what is the purpose of the WHERE clause?

• To specify which rows should be updated

• To limit the number of columns updated

• To check for foreign key constraints

• To sort the data before updating

Which of the following SQL statements is not used to modify data in a table?

• UPDATE

• DELETE

• INSERT

• SELECT