Your organization uses a relational database to store customer contact information. You need to modify the schema of the relational database.
Which component identifies this information?
A. Query language (QL)
B. Data control language (DCL)
C. Data definition language (DDL)
D. Data manipulation language (DML)
The correct answer is C.
The data definition language (DDL) identifies the schema of the database. The schema of a database defines the type of data that the database can store and manipulate. The schema is the description of a relational database. The schema also defines the properties of the type of data that a database can store as valid data objects. DDL is also used to create and delete views and relations between tables.
The query language (QL) is used to generate a request for information from a user in the form of query statements to obtain relevant output.
The data control language (DCL) manages access control to records in a database. DCL defines the granular user permissions to various data objects and implements database security. Examples of DCL commands are grant, deny, revoke, delete, update, and read.
The data manipulation language (DML) refers to a suite of computer languages used by database users to retrieve, insert, delete, and update data in a database. DML provides users the ability to store, retrieve, and manipulate the data according to the relevant instructions issued.
CISSP Certification Prep Course