This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Explain sequences and their relationship to surrogate keys. What will be an ideal ... (Read 74 times)

Brittanyd9008

  • Hero Member
  • *****
  • Posts: 500
on: Jul 7, 2018
Explain sequences and their relationship to surrogate keys.
 
  What will be an ideal response?

Question 2

For use with this book, it is recommended that MySQL be configured as a developer machine.
 
  Indicate whether the statement is true or false


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

Jody Vaughn

  • Sr. Member
  • ****
  • Posts: 344
Reply #1 on: Jul 7, 2018
Answer to Question 1

A sequence is an Oracle Database object that generates a sequential series of unique numbers. It allows the developer to specify the sequence's starting value and increment. Sequences are useful for specifying surrogate keys. The sequence methods CurrVal and NextVal may be used to access the row with the current sequence number and the next sequence number respectively. Using sequences, however, does not guarantee valid surrogate key values. For example, there is nothing that forces the surrogate key field to use the numbers generated by the sequence; therefore, a record may be inserted that does not follow the sequence. This means code must be written to control surrogate key values when sequences are used. Nonetheless, sequences are the best way to work with surrogate keys in Oracle Database.

Answer to Question 2

FALSE


Brittanyd9008

  • Member
  • Posts: 500
Reply 2 on: Jul 7, 2018
Gracias!

duy1981999

  • Member
  • Posts: 341
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

Studies show that systolic blood pressure can be significantly lowered by taking statins. In fact, the higher the patient's baseline blood pressure, the greater the effect of statins on his or her blood pressure.

Did you know?

The average office desk has 400 times more bacteria on it than a toilet.

Did you know?

It is important to read food labels and choose foods with low cholesterol and saturated trans fat. You should limit saturated fat to no higher than 6% of daily calories.

Did you know?

Eating carrots will improve your eyesight. Carrots are high in vitamin A (retinol), which is essential for good vision. It can also be found in milk, cheese, egg yolks, and liver.

Did you know?

The most common treatment options for addiction include psychotherapy, support groups, and individual counseling.

A common organization of sequences for the promoter of a eukaryotic structural gene A common organization of sequences for the promoter of a eukaryotic structural gene
The relationship between pH, pKa, and the dissociation of an acid The relationship between pH, pKa, and the dissociation of an acid
Model of the GABA Receptor–Chloride Channel Molecules in Relationship to Antiseizure Pharmacotherapy Model of the GABA Receptor–Chloride Channel Molecules in Relationship to Antiseizure Pharmacotherapy
Relationship Between Physical Activity and Improved Health Benefits Relationship Between Physical Activity and Improved Health Benefits
The relationship of substrate con- version (as measured by optical density) to the amount of patient ... The relationship of substrate con- version (as measured by optical density) to the amount of patient ...
Promoter consensus sequences for transcription initiation by RNA polymerase I Promoter consensus sequences for transcription initiation by RNA polymerase I
Video: Brief Summary on Photosynthesis - Animation

For a complete list of videos, visit our video library