Which SQL command is used to modify existing records in a table?
- DELETE
- INSERT
- SELECT
- UPDATE
The UPDATE command in SQL is used to modify existing records in a table. It allows users to change the values of one or more columns in one or more rows in a table based on specified conditions. It's commonly used to update data when there are changes or corrections needed in the database.
Loading...
Related Quiz
- In Visual Explain, what does a red arrow between nodes typically indicate?
- How can you optimize performance when using views in DB2?
- Which term refers to the process of ensuring continuous access to data in the event of a system failure?
- In what scenarios would an organization opt for alternative IDEs over IBM Data Studio for managing DB2 databases?
- How does the DEFERRABLE constraint affect the timing of constraint checking in DB2?