1.2 Structured Query Language

Question 1

Structured Query Language (SQL)

Answer 1

high-level computer language for storing, manipulating, and retrieving data

Question 2

SQL statement

Answer 2

a complete command composed of one or more clauses

Question 3

clause

Answer 3

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

Question 4

Literals

Answer 4

Explicit values that are string, numeric, or binary.
Strings must be surrounded by single quotes or double quotes.

Question 5

Keywords

Answer 5

Words with special meaning

ex: SELECT, FROM, WHERE

Question 6

identifiers

Answer 6

Objects from the database like tables, columns, etc.

ex: City, Name, Population

Question 7

Data Definition Language (DDL)

Answer 7

defines the structure of the database

DDL creates, alters, and drops tables

Question 8

Data Query Language (DQL)

Answer 8

retrieves data from the database.

Question 9

Data Manipulation Language (DML)

Answer 9

manipulates data stored in a database.

Question 10

Data Control Language (DCL)

Answer 10

controls database user access.

Question 11

Data Transaction Language (DTL)

Answer 11

manages database transactions.