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

Atropine, along with scopolamine and hyoscyamine, is found in the Datura stramonium plant, which gives hallucinogenic effects and is also known as locoweed.

Did you know?

Approximately 25% of all reported medication errors result from some kind of name confusion.

Did you know?

The term bacteria was devised in the 19th century by German biologist Ferdinand Cohn. He based it on the Greek word "bakterion" meaning a small rod or staff. Cohn is considered to be the father of modern bacteriology.

Did you know?

Nearly 31 million adults in America have a total cholesterol level that is more than 240 mg per dL.

Did you know?

Asthma occurs in one in 11 children and in one in 12 adults. African Americans and Latinos have a higher risk for developing asthma than other groups.

For a complete list of videos, visit our video library