CISSP Question of the Week: Relational Database

CISSP Question of the Week courtesy of Transcender Labs.

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)

Reveal Answer

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.

 

Related Course
CISSP Certification Prep Course

CISSP Question of the Week Series

• CISSP Question of the Week: Pillar of Basel II
• CISSP Question of the Week: Implement Redundant Servers
• CISSP Question of the Week: Terrorist Attacks
• CISSP Question of the Week: Customer Credit Card Information
• CISSP Question of the Week: Complex Instruction Set Computers
• CISSP Question of the Week: Asymmetric Encryption
• CISSP Question of the Week: OSI Layer for Formatting Data
• CISSP Question of the Week: Secure Communications
• CISSP Question of the Week: Biometric System and Fingerprinting Technology
• CISSP Question of the Week: Security Management Life Cycle
• CISSP Question of the Week: Anomaly-based Monitoring
• CISSP Question of the Week: Forensic Investigation
• CISSP Question of the Week: File Backup
• CISSP Question of the Week: Relational Database

from
CERTIVIEW