Q724
If a column contains 7 values and 6 distinct values, the cardinality is . . . . . . . .
A.
7
B.
6
AnswerC.
13
D.
1
Answer: Option B
Solution
Answer: Option B
Solution:
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.