Which sublanguage is used to query or retrieve data from a database?

Which sublanguage is used to query or retrieve data from a database?

• A. DDL
• B. DML
• C. DRL
• D. DCL

Answer: (C)

Data Manipulation Language handles working with the data itself. It’s the part of SQL that lets you retrieve information as well as insert, update, or delete rows. The act of querying data is done mainly with the SELECT statement, which sits under DML, not under the other sublanguages. DDL deals with defining or altering the database structure (like creating tables), DCL controls who can access data (permissions such as GRANT and REVOKE), and DRL isn’t a standard SQL term. So the operation described—querying or retrieving data from a database—fits Data Manipulation Language.

Data Manipulation Language handles working with the data itself. It’s the part of SQL that lets you retrieve information as well as insert, update, or delete rows. The act of querying data is done mainly with the SELECT statement, which sits under DML, not under the other sublanguages. DDL deals with defining or altering the database structure (like creating tables), DCL controls who can access data (permissions such as GRANT and REVOKE), and DRL isn’t a standard SQL term. So the operation described—querying or retrieving data from a database—fits Data Manipulation Language.