oracle interview question - What is SQL, What are the types of SQL statements

List of all the SQL and PLSQL interview questions @ https://sivakacademy.blogspot.com/p/s...

-----------------------------------------------------------------------------------------------------------

SQL stands for Structured query language,
In simpler terms it’s the way to communicate with the database, what I mean by communication here is , any instruction we want to give to database would be through SQL.

So, these instructions are nothing but commands or statements in SQL.

For instance, if you want to store some new data into database, then you need to use "INSERT" statement. similarly if you want to remove some data, then you need to use "DELETE" statement.

Depends on the functionality of these instructions or statements, the SQL statements are broadly classified into five sub categories, or five SUB SQL languages as given below,

DDL ( Data Definition Language )
DML ( Data manipulation Language )
DCL ( Data Control language )
TCL ( Transaction Control Language )
DRL ( Data Retrieval Language )

These language are classified based on the core functionality they perform, Given below commands for each language.

DDL – CREATE, ALTER, DROP, TRUNCATE
DML – INSERT, UPDATE, DELETE
DCL – GRANT, REVOKE
TCL – COMMIT, ROLLBACK, SAVEPOINT
DRL – SELECT