SQL Languages

Question 1

What are the types of structured query language that exist?

Answer 1

DDL
DML
DCL
TCL
DQL
DAL

Question 2

What does DLL stand for, what does it do, and what examples of its commands?

Answer 2

Data Defination Language, it is used to define and manage the structure of a database.
Examples: CREAT, TRUNCATE, DROP, ALTER

Question 3

What does DML stand for, what does it do, and what examples of its commands?

Answer 3

Data Manipulation Language, it is used to manipulate and retrive data in a database

Examples: SELECT, DELETE, UPDATE, INSERT

Question 4

What does DCL stand for, what does it do, and what examples of its commands?

Answer 4

Data Control Language it is use to control a database and manage user privilages

Examples: GRANT, REVOKE, DENY

Question 5

What does TCL stand for, what does it do, and what examples of its commands?

Answer 5

Transaction Control Language, it is used to manage database transactions.

Examples: COMMIT, ROLLBACK, SAVEPOINT

Question 6

What does stand DQL for, what does it do, and what examples of its commands?

Answer 6

Data Querry Language, it is used to select and retrive database data.

Example: SELECT

Question 7

What does DAL stand for, what does it do, and what examples of its commands?

Answer 7

Data Administration Language, it is used to database management and maintanace