All DDL, DML, DCL, and TCL statements of SQL can be used in database testing,
DDL (Data Definition Language) : All statements related to this can be used in defining the database structure or schema.
Statements : CREATE, ALTER, DROP, TRUNCATE, COMMENT, and RENAME
DML (Data Manipulation Language) : All statements related to this can be used for managing data within schema objects.
Statements : SELECT, INSERT, UPDATE, DELETE, MERGE, CALL, EXPLAIN PLAN, and LOCK TABLE
.
DCL (Data Control Language) : GRANT
Statement and REVOKE
Statement.
TCL (Transaction Control Language) : All statements related to this can be used to manage the changes made by DML statements. Using TCL, statements can be grouped together into logical transactions.
Statements : COMMIT, SAVEPOINT, ROLLBACK, and SET TRANSACTION
.