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

Human neurons are so small that they require a microscope in order to be seen. However, some neurons can be up to 3 feet long, such as those that extend from the spinal cord to the toes.

Did you know?

A cataract is a clouding of the eyes' natural lens. As we age, some clouding of the lens may occur. The first sign of a cataract is usually blurry vision. Although glasses and other visual aids may at first help a person with cataracts, surgery may become inevitable. Cataract surgery is very successful in restoring vision, and it is the most frequently performed surgery in the United States.

Did you know?

Everyone has one nostril that is larger than the other.

Did you know?

There are 20 feet of blood vessels in each square inch of human skin.

Did you know?

Though methadone is often used to treat dependency on other opioids, the drug itself can be abused. Crushing or snorting methadone can achieve the opiate "rush" desired by addicts. Improper use such as these can lead to a dangerous dependency on methadone. This drug now accounts for nearly one-third of opioid-related deaths.

For a complete list of videos, visit our video library