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.

C

Computer Science & Information Technology

You might also like to view...

Entering a company's restricted area by following closely behind an authorized person is referred to as which of the following?

a. Shoulder surfing b. Piggybacking c. False entering d. Social engineering

Computer Science & Information Technology

?To force a document to appear in a new window or tab, identify an attribute that should be added to tag.

A. ?href B. ?target C. ?start D. ?role

Computer Science & Information Technology