Which of the following is a column or collection of columns on which all columns in the table are functionally dependent?
A) index key
B) candidate key
C) major key
D) special key

Question

Quizplus · Accepted Answer

A candidate key is a column or collection of columns that can uniquely identify each row in a table. Therefore, all other columns in the table are functionally dependent on the candidate key. The other options (A, C, D) are not commonly used or recognized terms in the database field.

Which of the Following Is a Column or Collection of Columns