SQL query and modification commands make up a(n) ________ .
A. DDL
B. DML
C. HTML
D. XML
Answer: Option A
Solution (By Examveda Team)
Option A: DDL - DDL stands for Data Definition Language in SQL. It consists of commands used to define, modify, and remove database objects such as tables and indexes. Examples include CREATE, ALTER, and DROP commands.Option B: DML - DML stands for Data Manipulation Language. It consists of commands used to manipulate data within database objects. Examples include INSERT, UPDATE, and DELETE commands.
Option C: HTML - HTML (Hypertext Markup Language) is not related to SQL query and modification commands. This option is incorrect.
Option D: XML - XML (eXtensible Markup Language) is not related to SQL query and modification commands. This option is incorrect.
Conclusion:
SQL query and modification commands that define and manipulate database objects are categorized under Option A: DDL (Data Definition Language). These commands are used to manage the structure and schema of the database.
This Question Belongs to Database >> Introduction To SQL
You can add a row using SQL in a database with which of the following?
A. ADD
B. CREATE
C. INSERT
D. MAKE
The command to remove rows from a table 'CUSTOMER' is:
A. REMOVE FROM CUSTOMER ...
B. DROP FROM CUSTOMER ...
C. DELETE FROM CUSTOMER WHERE ...
D. UPDATE FROM CUSTOMER ...
A. limits the column data that are returned.
B. limits the row data are returned.
C. Both A and B are correct.
D. Neither A nor B are correct.
Which of the following is the original purpose of SQL?
A. To specify the syntax and semantics of SQL data definition language
B. To specify the syntax and semantics of SQL manipulation language
C. To define the data structures
D. All of the above
Join The Discussion