Match the descriptions to these writes terms: INSERT, UPDATE, DELETE, UPSERT.

WritesConcept relationships

Choose a match for every item. Use each answer once.

DELETE removes rows while preserving the table definition.

INSERT creates rows while applying the table's defaults and constraints.

UPDATE modifies selected rows and needs an appropriate condition when only some rows should change.

Upsert combines creation and conflict handling according to the database's supported syntax.

Loading question…