Vidyalelo
MySQL · Q724

MySQL

Programming · MySQL · question 724

Q724

If a column contains 7 values and 6 distinct values, the cardinality is . . . . . . . .

A.
7
B.
6
Answer
C.
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.