A(n)____ 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

A(n)____ 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

Quizplus · Accepted Answer

A candidate key is a column or collection of columns on which all columns in the table are functionally dependent. It is a potential primary key for a table and can uniquely identify each row in the table. An index key is a database object that improves the speed of data retrieval operations on a table. A major key and special key are not commonly used terms in database design.

A(n)____ Is a Column or Collection of Columns on Which