Which of the following is NOT a function of Data Definition Language (DDL)?

Which of the following is NOT a function of Data Definition Language (DDL)?

• A. Modifying data entries
• B. Creating database objects
• C. Defining indexes
• D. Setting relationships between tables

Answer: (A)

Data Definition Language (DDL) is a subset of SQL used for defining and managing the structure of a database. DDL commands include creating, altering, and deleting database objects like tables and indexes. The primary functions of DDL involve operations that establish and modify how data is organized rather than the data itself. Modifying data entries falls outside the scope of DDL, as it pertains to Data Manipulation Language (DML). DML commands, such as INSERT, UPDATE, and DELETE, are specifically designed for handling actual data within the database. Therefore, while DDL can change the structure of a database, it does not manage the content or entries of that database, making the other options—creating database objects, defining indexes, and setting relationships between tables—all functions associated with DDL.

Data Definition Language (DDL) is a subset of SQL used for defining and managing the structure of a database. DDL commands include creating, altering, and deleting database objects like tables and indexes. The primary functions of DDL involve operations that establish and modify how data is organized rather than the data itself.

Modifying data entries falls outside the scope of DDL, as it pertains to Data Manipulation Language (DML). DML commands, such as INSERT, UPDATE, and DELETE, are specifically designed for handling actual data within the database. Therefore, while DDL can change the structure of a database, it does not manage the content or entries of that database, making the other options—creating database objects, defining indexes, and setting relationships between tables—all functions associated with DDL.