Which statement best describes the relationship of SQL sublanguages?

Which statement best describes the relationship of SQL sublanguages?

• A. They are all unrelated
• B. They are all the same
• C. They group statements by function into DDL, DML, DRL, DCL, and Transaction Control
• D. They only handle data retrieval

Answer: (C)

SQL is organized into function-based sublanguages: DDL (Data Definition Language) for schema and object definitions, DML (Data Manipulation Language) for data changes, DCL (Data Control Language) for permissions, and Transaction Control for managing transactions. This separation reflects how different statements affect different aspects of the database and helps keep structure, data, security, and consistency concerns distinct. For example, DDL includes CREATE, ALTER, and DROP to define or modify objects like tables; DML covers SELECT, INSERT, UPDATE, and DELETE to work with the actual data; DCL includes GRANT and REVOKE to control access; and Transaction Control covers COMMIT, ROLLBACK, and SAVEPOINT to manage transactional boundaries. The other options don’t fit because they either ignore this functional grouping, claim every sublanguage is the same or unrelated, or mischaracterize SQL by suggesting it only handles data retrieval.

SQL is organized into function-based sublanguages: DDL (Data Definition Language) for schema and object definitions, DML (Data Manipulation Language) for data changes, DCL (Data Control Language) for permissions, and Transaction Control for managing transactions. This separation reflects how different statements affect different aspects of the database and helps keep structure, data, security, and consistency concerns distinct. For example, DDL includes CREATE, ALTER, and DROP to define or modify objects like tables; DML covers SELECT, INSERT, UPDATE, and DELETE to work with the actual data; DCL includes GRANT and REVOKE to control access; and Transaction Control covers COMMIT, ROLLBACK, and SAVEPOINT to manage transactional boundaries. The other options don’t fit because they either ignore this functional grouping, claim every sublanguage is the same or unrelated, or mischaracterize SQL by suggesting it only handles data retrieval.