For this exercise, drag and drop the type of statement with its correct definition.

Match the command with its correct definition.

Provide an example SQL statement for two of the statements

Describe in a few sentences the guidelines for designing databases with the two SQL statements you have selected.

INSERT CREATE DELETE UPDATE TRUNCATE COMMIT ROLLBACK GRANT REVOKE DROP

prevents a user from accessing a specified database.

permanently records the row changes.

creates a database structure.

adds rows to a table.

removes a database structure.

undoes the row changes.

gives a user access to a specified database structure.

deletes all the rows from a table.

changes rows.

removes rows.