Which of the following is used to create and modify the structure of your tables and other objects in the
database?
A.
SQL Data Definition Language (DDL)
B.
SQL Data Manipulation Language (DML)
C.
SQL Data Relational Language (DRL)
D.
SQL Data Identification Language (DIL)
Explanation:
The Data Definition Language (DDL) is similar to a computer programming language and is used for defining
data structures, such as database schemas, database tables, and other database objects.
Incorrect Answers:
B: The Data Manipulation Language (DML) is used to retrieve, insert and modify database data. These
commands will be used by all database users during the routine operation of the database.
C: The SQL language consists of three components: the Data Definition Language (DDL), the Data
Manipulation Language (DML), and the Data Control Language (DCL). It does not contain a data relational
language.
D: The SQL language consists of three components: the Data Definition Language (DDL), the Data
Manipulation Language (DML), and the Data Control Language (DCL). It does not contain a data identification
language.Harris, Shon, All In One CISSP Exam Guide, 6th Edition, McGraw-Hill, New York, 2013, p. 1177