What does the INSERT statement do? a. Fetch data from a database b. Insert new rows into a table c. Insert new columns into a table d. Insert a new table into a database

SQL (Structured Query Language) Statements refer to the various commands and instructions used in SQL to interact with relational databases. SQL is a standardized language for managing and querying data in relational database management systems (RDBMS), and it provides a set of statements for performing different tasks.

Here are some common categories of SQL statements:

1. Data Querying Statements :

• SELECT:  Used to retrieve data from one or more tables. It allows you to specify which columns to retrieve, conditions for filtering data, and more.

2. Data Manipulation Statements:

• INSERT: As discussed earlier, it is used to add new rows of data into a table.
• UPDATE: Used to modify existing data in a table based on specified conditions.
• DELETE: Used to remove rows from a table based on specified conditions.

3. Data Definition Statements:

• CREATE TABLE: Used to define a new table, including specifying the columns, data types, constraints, and indexes.
• ALTER TABLE: Used to modify an existing table's structure, such as adding, modifying, or deleting columns.
• DROP TABLE: Used to delete an existing table and all its data.
• CREATE INDEX: Used to create an index on one or more columns of a table to improve query performance.

4. Data Control Statements:

• GRANT: Used to grant specific privileges or permissions to users or roles on database objects.
• REVOKE: Used to revoke previously granted privileges from users or roles.

5. Transaction Control Statements:

• BEGIN TRANSACTION (or BEGIN): Starts a new transaction.
• COMMIT: Saves changes made during the transaction to the database.
• ROLLBACK: Undoes changes made during the transaction and restores the database to its previous state.