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
You might also like to view...
The primary interface/interfaces for a collection class is/are:
(a) Collection
Briefly describe the Database Vault.
What will be an ideal response?
Malware is software designed to infiltrate a computer system without the users consent
Indicate whether the statement is true or false
A community of XSLT developers created a standard collection of extension elements and extension functions called EXSLT.?
Answer the following statement true (T) or false (F)