?
If a column contains 7 values and 6 distinct values, the cardinality is . . . . . . . .
Answer & Solution
Correct Answer:
Option
B
This question is about cardinality in MySQL. Cardinality measures how many unique values are present in a column.
Imagine a column with these values:
Apple, Orange, Apple, Banana, Pear, Orange, Grape
We have 7 values in total, but only 6 unique values (Apple, Orange, Banana, Pear, Grape).
So, the cardinality is 6.
Therefore, the correct answer is Option B: 6.
Imagine a column with these values:
Apple, Orange, Apple, Banana, Pear, Orange, Grape
We have 7 values in total, but only 6 unique values (Apple, Orange, Banana, Pear, Grape).
So, the cardinality is 6.
Therefore, the correct answer is Option B: 6.
Join the Discussion
Login to post a comment or share your explanation.
Login