Q: Which of the following DDL statements is used to create a new index on multiple columns of a table in MySQL?  

Answer: C

The CREATE INDEX statement in MySQL is used to create a new index on one or more columns of a table. It improves query performance by allowing faster data retrieval based on the indexed columns.

Click me to Read more Question & Answer of Data definition language - MySQL

---

Share this MCQ