1.2 Structured Query Language

Question 1

What is Structured Query Language (SQL)?

Answer 1

Structured Query Language (SQL) is a high-level computer language for storing, manipulating, and retrieving data.

Question 2

What is an SQL statement?

Answer 2

An SQL statement is a complete command composed of one or more clauses.

Question 3

What is a clause in SQL?

Answer 3

A clause groups SQL keywords like SELECT, FROM, and WHERE with table names like City, column names like Name, and conditions like Population > 100000.

Question 4

What is Data Definition Language (DDL)?

Answer 4

Data Definition Language (DDL) defines the structure of the database.

Question 5

What is Data Query Language (DQL)?

Answer 5

Data Query Language (DQL) retrieves data from the database.

Question 6

What is Data Manipulation Language (DML)?

Answer 6

Data Manipulation Language (DML) manipulates data stored in a database.

Question 7

What is Data Control Language (DCL)?

Answer 7

Data Control Language (DCL) controls database user access.

Question 8

What is Data Transaction Language (DTL)?

Answer 8

Data Transaction Language (DTL) manages database transactions.