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

There are more bacteria in your mouth than there are people in the world.

Did you know?

Eat fiber! A diet high in fiber can help lower cholesterol levels by as much as 10%.

Did you know?

Carbamazepine can interfere with the results of home pregnancy tests. If you are taking carbamazepine, do not try to test for pregnancy at home.

Did you know?

Asthma cases in Americans are about 75% higher today than they were in 1980.

Did you know?

To combat osteoporosis, changes in lifestyle and diet are recommended. At-risk patients should include 1,200 to 1,500 mg of calcium daily either via dietary means or with supplements.

For a complete list of videos, visit our video library