Q. What does the CREATE INDEX Statement do?

  • (A) An index is created in a SQL database table with this SQL statement.
  • (B) Changes made in the SQL database transaction are permanently saved using this SQL statement.
  • (C) By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
  • (D) The SQL database table's index is deleted using this SQL statement.
💬 Discuss
✅ Correct Answer: (A) An index is created in a SQL database table with this SQL statement.
Explanation: An index is created in a SQL database table with CREATE INDEX SQL statement.

Published by Tina Singh ⭐ 14.41K Points at 13-Feb-2023 07:45 am in MySQL

Explanation by: Tina Singh
An index is created in a SQL database table with CREATE INDEX SQL statement.

💬 Discussion

📊 Question Analytics

👁️
213
Total Visits
📽️
4 y ago
Published
🎖️
Tina Singh
Publisher
📈
85%
Success Rate