Which of the Following Is NOT True When Deciding When

Multiple Choice

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.