By default,Access and other DBMSs create indexes automatically for the ____ keys.
A) primary and minor
B) alternate and foreign
C) secondary and alternate
D) primary and foreign

Question

By default,Access and other DBMSs create indexes automatically for the ____ keys.​
A) ​primary and minor
B) ​alternate and foreign
C) ​secondary and alternate
D) ​primary and foreign

Quizplus · Accepted Answer

By default, Access and other DBMSs create indexes automatically for the primary key and foreign keys. Primary keys are used by the DBMS to uniquely identify each record in a table, while foreign keys are used to establish relationships between tables. Therefore, option D, primary and foreign, is the best choice.

By Default,Access and Other DBMSs Create Indexes Automatically for the ____