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 62 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
:D TYSM

Zebsrer

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

« previous next »
 

Did you know?

Parkinson's disease is both chronic and progressive. This means that it persists over a long period of time and that its symptoms grow worse over time.

Did you know?

The average person is easily confused by the terms pharmaceutics and pharmacology, thinking they are one and the same. Whereas pharmaceutics is the science of preparing and dispensing drugs (otherwise known as the science of pharmacy), pharmacology is the study of medications.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Did you know?

People about to have surgery must tell their health care providers about all supplements they take.

Did you know?

Between 1999 and 2012, American adults with high total cholesterol decreased from 18.3% to 12.9%

The metabolic pathway that breaks down phenylalanine and its relationship to certain genetic disease The metabolic pathway that breaks down phenylalanine and its relationship to certain genetic disease
Structure of the ovary and uterine (fallopian) tube. Figure illustrates stages of ovum development a Structure of the ovary and uterine (fallopian) tube. Figure illustrates stages of ovum development a
Relationship Between Training Intensity and VO2max Improvement Relationship Between Training Intensity and VO2max Improvement
A relationship between folate and B12 metabolism A relationship between folate and B12 metabolism
Sequencing a large chromosome by individual sequence determination of cloned fragments in sequences Sequencing a large chromosome by individual sequence determination of cloned fragments in sequences
The three possible sequences of the white, yellow, and echinus genes The three possible sequences of the white, yellow, and echinus genes
Video: Brief Summary on Photosynthesis - Animation

For a complete list of videos, visit our video library