Author Question: Which of the following is NOT true when deciding when to use a surrogate key? A) The advantage ... (Read 76 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?

Most strokes are caused when blood clots move to a blood vessel in the brain and block blood flow to that area. Thrombolytic therapy can be used to dissolve the clot quickly. If given within 3 hours of the first stroke symptoms, this therapy can help limit stroke damage and disability.

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

Did you know?

Cyanide works by making the human body unable to use oxygen.

Did you know?

Earwax has antimicrobial properties that reduce the viability of bacteria and fungus in the human ear.

Did you know?

Critical care patients are twice as likely to receive the wrong medication. Of these errors, 20% are life-threatening, and 42% require additional life-sustaining treatments.

For a complete list of videos, visit our video library