Q. Which among the following is the correct syntax for defining "ENUM" in Mysql?

  • (A) gender ENUM ('M', 'F'),
  • (B) gender ENUM,
  • (C) gender ENUM ( ),
  • (D) none of the mentioned
💬 Discuss
✅ Correct Answer: (A) gender ENUM ('M', 'F'),
Explanation: This question is about ENUM in MySQL, which is a special data type used to define a column that can only hold a specific set of values. Imagine you have a column called "gender," and you only want it to contain either "Male" or "Female." This is where ENUM comes in handy. Here's the breakdown of the options: * Option A: gender ENUM ('M', 'F')

Published by Shiva Ram ⭐ 30.44K Points at 22-Mar-2025 12:48 pm in MySQL

Explanation by: Shiva Ram
This question is about ENUM in MySQL, which is a special data type used to define a column that can only hold a specific set of values. Imagine you have a column called "gender," and you only want it to contain either "Male" or "Female." This is where ENUM comes in handy. Here's the breakdown of the options: * Option A: gender ENUM ('M', 'F')

💬 Discussion

📊 Question Analytics

👁️
121
Total Visits
📽️
2 y ago
Published
🎖️
Shiva Ram
Publisher
📈
84%
Success Rate