Which scenario below indicates HIGH cardinality column?

technology databases

  1. Scenario 1 : Distinct values for TableA.ColumnA = 10 Total no. of rows for TableA = 100

  2. Scenario 2 : Distinct values for TableA.ColumnB = 20 Total no. of rows for TableA = 100

  3. Scenario 3 : Distinct values for TableA.ColumnC = 30 Total no. of rows for TableA = 100

  4. Distinct values have no corelation to cardinality

Show answer
Correct Option: C

Find more quizzes: