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