Author Question: Which of the following is NOT true when deciding when to use a surrogate key? A) The advantage ... (Read 34 times)

bclement10

  • Hero Member
  • *****
  • Posts: 560
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 2

A table is a collection of data or fields.
 
  Indicate whether the statement is true or false



snackralk

  • Sr. Member
  • ****
  • Posts: 363
Answer to Question 1

C

Answer to Question 2

TRUE



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question


 

Did you know?

Long-term mental and physical effects from substance abuse include: paranoia, psychosis, immune deficiencies, and organ damage.

Did you know?

Only 12 hours after an egg cell is fertilized by a sperm cell, the egg cell starts to divide. As it continues to divide, it moves along the fallopian tube toward the uterus at about 1 inch per day.

Did you know?

Ether was used widely for surgeries but became less popular because of its flammability and its tendency to cause vomiting. In England, it was quickly replaced by chloroform, but this agent caused many deaths and lost popularity.

Did you know?

Famous people who died from poisoning or drug overdose include, Adolf Hitler, Socrates, Juan Ponce de Leon, Marilyn Monroe, Judy Garland, and John Belushi.

Did you know?

Disorders that may affect pharmacodynamics include genetic mutations, malnutrition, thyrotoxicosis, myasthenia gravis, Parkinson's disease, and certain forms of insulin-resistant diabetes mellitus.

For a complete list of videos, visit our video library