In MySQL, which of the following operations requires the use of a DDL command?
2026
In MySQL, which of the following operations requires the use of a DDL command?
Answer: B. Changing the degree of a table — The correct answer is Option B (Changing the degree of a table). DDL (Data Definition Language) commands are used to define or modify the structure of a…
- A.
Changing the cardinality of a table
- B.
Changing the degree of a table
- C.
Modifying the data within a single tuple
- D.
Modifying the data within multiple tuples
Attempted by 944 students.
Show answer & explanation
Correct answer: B
The correct answer is Option B (Changing the degree of a table).
DDL (Data Definition Language) commands are used to define or modify the structure of a database. Changing the degree of a table means adding or removing columns, which changes the structure of the table. This is done using DDL commands like ALTER TABLE.
Other options involve modifying data (rows), which comes under DML (Data Manipulation Language), not DDL.
Thus, changing the degree of a table requires a DDL command.