COMMIT is a Transaction Control Language (TCL) command used to save all changes made during the current transaction.

TRUNCATE is a DDL command that removes all rows from a table and resets the high water mark, whereas DELETE is a DML command.

GRANT is a DCL command used to give users access privileges to database objects.

SELECT is used to query and retrieve data from a database, categorizing it under Data Manipulation Language (DML) in most SQL standards.

DROP is a DDL command that deletes both the table structure and its data from the database.

CREATE is a DDL command, while INSERT, UPDATE, and DELETE are standard DML commands.

ROLLBACK is a TCL command used to undo changes made in the current transaction that have not yet been committed.

REVOKE is a DCL command used to remove access privileges that were previously granted to a user.

UPDATE is the standard DML command used to change or modify existing data within database records.

The ALTER command belongs to DDL (Data Definition Language) and is used to modify the structure of database objects like tables.

REVOKE is a DCL command used to remove previously granted permissions or privileges from a user or role.

CREATE is a fundamental DDL command used to define and create database schema objects.

INSERT is a DML (Data Manipulation Language) command used to populate tables with new data records.

TRUNCATE is a DDL command because it resets the high-water mark of the table and does not log individual row deletions, making it faster than DELETE.

The RENAME command is a DDL command specifically used to change the name of an existing database object.

COMMIT is a Transaction Control Language (TCL) command used to save the changes made by DML operations permanently.

DELETE is a DML command that allows row-level removal using a WHERE clause.

GRANT is a DCL command used to grant access privileges to database users.

ALTER is a DDL command, which are often referred to as Schema commands as they define and modify the structure of database objects.