What operations can Data Manipulation Language (DML) perform?

What operations can Data Manipulation Language (DML) perform?

• A. Creating and deleting tables
• B. Inserting, updating, and deleting records
• C. Defining data types and constraints
• D. Establishing database connections

Answer: (B)

Data Manipulation Language (DML) is specifically designed to manage data within a relational database. Its primary operations include inserting new records into tables, updating existing records, and deleting records from tables. These operations are fundamental for manipulating the data stored in a database, allowing users to change data as needed while maintaining its structure. In contrast, options related to creating and deleting tables, defining data types and constraints, or establishing database connections fall under different categories of SQL. Creating and deleting tables is handled by Data Definition Language (DDL), which focuses on the structure of the database itself. Defining data types and constraints is also a DDL operation. Establishing database connections is typically managed by other programming constructs outside of DML commands. Therefore, the correct choice reflects the specific capabilities of DML in the context of data management.

Data Manipulation Language (DML) is specifically designed to manage data within a relational database. Its primary operations include inserting new records into tables, updating existing records, and deleting records from tables. These operations are fundamental for manipulating the data stored in a database, allowing users to change data as needed while maintaining its structure.

In contrast, options related to creating and deleting tables, defining data types and constraints, or establishing database connections fall under different categories of SQL. Creating and deleting tables is handled by Data Definition Language (DDL), which focuses on the structure of the database itself. Defining data types and constraints is also a DDL operation. Establishing database connections is typically managed by other programming constructs outside of DML commands. Therefore, the correct choice reflects the specific capabilities of DML in the context of data management.