(i) Truncate: Remove all records from a table, also release the space occupied by those records.
(ii) Delete: Deletes all records from a table, but not the space occupied by them.
(iii) Revoke: Withdraws the access permission given by the GRANT statement.

(i) Commit: Saves any transaction into the database permanently.
(ii) Roll back: Restores the database to last commit state.
(iii) Save point: Temporarily save a transaction so that you can rollback.

Transactional Control Language (TCL) commands are used to manage transactions in the database. These are used to manage the changes made to the data in a table by DML statements.

(i) Insert: Inserts data into a table
(ii) Update: Updates the existing data within a table.
(iii) Delete: Deletes all records from a table, but not the space occupied by them.

The DML is basically of two types:
(i) Procedural DML - Requires a user to specify what data is needed and how to get it.
(ii) Non-Procedural DML - Requires a user to specify what data is needed without specifying how to get it.

(i) A Data Manipulation Language (DML) is a computer programming language used for adding (inserting), removing (deleting), and modifying (updating) data in a database. In SQL, the data manipulation language comprises the SQL-data change statements, which modify stored data but not the schema of the database table.
(ii) After the database schema has been specified and the database has been created, the data can be manipulated using a set of procedures which are expressed by DML.

(i) Create: To create tables in the database.
(ii) AIter: Alters the structure of the database.
(iii) Drop: Delete tables from database.
(iv) Truncate: Remove all records from a table, also release the space occupied by those records.

Functions performed by DDL:
(i) The Data Definition Language (DDL) consist of SQL statements used to define the database structure or schema. It simply deals with descriptions of the database schema and is used to create and modify the structure of database objects in databases
(ii) The DDL provides a set of definitions to specify the storage structure and access methods used by the database system.

WAMP stands for "Windows, Apache, MySQL and PHP" It is often used for web development and internal testing, but may be also be used to serve live websites.

(i) DDL - Data Definition Language
(ii) DML - Data Manipulation Language
(iii) WAMP - Windows, Apache, MySQL, PHP

To create a database, type the following command in the prompt:
CREATE DATABASE database_name;
For example; To create a database to store the tables:
CREATE DATABASE stud;
(ii) To work with the database, type the following command.
USE DATABASE;
For example ; To use the stud database created, give the command USE stud;

RDBMS is a type of DBMS with a row-based table structure that connects related data elements and includes functions related to Create, Read, Update and Delete operations, collectively known as CRUD.

Oracle, MySQL, MS SQL Server, IBM DB2 and Microsoft Access are RDBMS packages.

(i) The Structured Query Language (SQL) is a standard programming language to access and manipulate databases.
(ii) SQL allows the user to create, retrieve, alter, and transfer information among databases.
(iii) It is a language designed for managing and accessing data in a Relational Data Base Management System (RDBMS).

(i) SQL -Structured Query Language
(ii) DBMS-Database Management System
(iii) RDBM - Relational Database Management System