What SQL statements have you used in Database Testing?
The most important statement for database testing is the SELECT statement, which returns data rows from one or multiple tables that satisfies a given set of criteria. We may need to use other DML (Data Manipulation Language) statements like INSERT, UPDATE and DELTE to manage our test data.
We may also need to use DDL (Data Definition Language) statements like CREATE TABLE, ALTER TABLE, and DROP TABLE to manage our test tables.
We may also need to some other commands to view table structures, column definitions, indexes, constraints and store procedures.