What does the INSERT INTO statement do in SQL?
- Adds new records
- Deletes records
- Sorts records
- Updates existing records
The INSERT INTO statement adds new records (rows) to a table in a database. It is used to insert a new row of data into a specified table with specified values for each column.
Loading...
Related Quiz
- Scenario: A company's DB2 database experiences a critical failure, and the primary server becomes unavailable. How can the company ensure minimal downtime and data loss?
- Denormalization is a process of ________ the normalized relational database schema.
- DB2 administrators can use ________ to gather real-time information about database activity.
- Which configuration file in DB2 stores database connection information?
- Scenario: A data analyst wants to calculate the total number of orders placed by each customer. Which aggregation function would be appropriate in DB2, and what additional operation may be required?