Podcast
Questions and Answers
What does the INSERT INTO statement do?
What does the INSERT INTO statement do?
- Add new records to a table (correct)
- Modify existing data in a table
- Remove existing data from a table
- Create a new table
What happens if you don't specify values for all columns in an INSERT statement?
What happens if you don't specify values for all columns in an INSERT statement?
- The table will be dropped
- The INSERT statement will fail
- An error will be thrown
- NULL will be added for the unspecified columns (correct)
What does the UPDATE statement do?
What does the UPDATE statement do?
- Create a new table
- Modify existing data in a table (correct)
- Add new records to a table
- Remove existing data from a table
Which DML statement is used to remove existing data from a database?
Which DML statement is used to remove existing data from a database?
What is the risk of using INSERT INTO without mentioning the columns?
What is the risk of using INSERT INTO without mentioning the columns?
Flashcards are hidden until you start studying