Lesson 2

Question 1

Data Definition Language (DDL)

Answer 1

Defines the structure of the database.

Ex. Create table Product.

Question 2

Data Query Language (DQL - SQL Sublanguage)

Answer 2

Retrieves data from the database.

Ex. Select all rows from a table.

Question 3

Data Manipulation Language (DML - SQL Sublanguage)

Answer 3

Manipulates data stored in a database.

Ex. Insert data row into table product.

Question 4

Data Control Language (DCL - SQL Sublanguage)

Answer 4

Controls the database user access.

Ex. Grant all permissions to the user ‘tester’.

Question 5

Data Transaction Language (DTL - SQL Sublanguage)

Answer 5

Manages database transactions.

Ex. Rollback database changes.