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 30 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

kjohnson

  • Member
  • Posts: 330
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

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?

It is believed that humans initially contracted crabs from gorillas about 3 million years ago from either sleeping in gorilla nests or eating the apes.

Did you know?

Cutaneous mucormycosis is a rare fungal infection that has been fatal in at least 29% of cases, and in as many as 83% of cases, depending on the patient's health prior to infection. It has occurred often after natural disasters such as tornados, and early treatment is essential.

Did you know?

Looking at the sun may not only cause headache and distort your vision temporarily, but it can also cause permanent eye damage. Any exposure to sunlight adds to the cumulative effects of ultraviolet (UV) radiation on your eyes. UV exposure has been linked to eye disorders such as macular degeneration, solar retinitis, and corneal dystrophies.

Did you know?

Symptoms of kidney problems include a loss of appetite, back pain (which may be sudden and intense), chills, abdominal pain, fluid retention, nausea, the urge to urinate, vomiting, and fever.

The organization of nucleotide sequences in bacterial chromosomal DNA. The organization of nucleotide sequences in bacterial chromosomal DNA.
The accessory organs of the digestive system: the liver, gallbladder, and pancreas. Image shows the The accessory organs of the digestive system: the liver, gallbladder, and pancreas. Image shows the
1 Representations of two consensus sequences. 1 Representations of two consensus sequences.
Blood pressure and blood volume relationship Blood pressure and blood volume relationship
What are examples of ideal forms? What are examples of ideal forms?
Relationship between thymidylate synthase and enzymes of tetrahydrofolate metabolism Relationship between thymidylate synthase and enzymes of tetrahydrofolate metabolism
Video: Mendel's Pea Experiment

For a complete list of videos, visit our video library