Which of the following is NOT true when deciding when to use a surrogate key?
A)The advantage with a surrogate key is that it can help prevent some cascading changes from primary to foreign key errors.
B)A surrogate key can increase the file size and require more joins.
C)If the key never has a foreign key,you need a surrogate key.
D)If you have a primary key with a foreign key that may need to be changed frequently or more than normal,a surrogate key should be considered.

Question

Quizplus · Accepted Answer

This statement is not true. It is not necessary to use a surrogate key if the primary key never has a foreign key. The decision to use a surrogate key should be based on factors such as the complexity of the primary key and the potential for frequent changes to the key.

Which of the Following Is NOT True When Deciding When