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 — In MySQL, DDL (Data Definition Language) commands are used to define or modify the structure of database objects like tables. Changing the degree of a table…
- 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 842 students.
Show answer & explanation
Correct answer: B
In MySQL, DDL (Data Definition Language) commands are used to define or modify the structure of database objects like tables. Changing the degree of a table (i.e., the number of columns) requires altering the table schema, which is done using a DDL command such as ALTER TABLE. Operations like inserting data or changing the number of rows are handled by DML (Data Manipulation Language) commands. Therefore, only modifying the table's degree requires a DDL command.