Q. Which of the following is a valid way to create an index?

  • (A) CREATE KEY idx_name ON table(column);
  • (B) MAKE INDEX idx_name ON table(column);
  • (C) CREATE INDEX idx_name ON table(column);
  • (D) SET INDEX ON table(column);
💬 Discuss
✅ Correct Answer: (C) CREATE INDEX idx_name ON table(column);
Explanation: `CREATE INDEX` is the correct syntax to create an index in MySQL.

Published by Mr. Dubey ⭐ 111.54K Points at 06-Jun-2025 10:33 pm in MySQL

Explanation by: Mr. Dubey
`CREATE INDEX` is the correct syntax to create an index in MySQL.

💬 Discussion

📊 Question Analytics

👁️
92
Total Visits
📽️
1 y ago
Published
🎖️
Mr. Dubey
Publisher
📈
91%
Success Rate