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 32 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
Excellent

sultansheikh

  • Member
  • Posts: 335
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

Interferon was scarce and expensive until 1980, when the interferon gene was inserted into bacteria using recombinant DNA technology, allowing for mass cultivation and purification from bacterial cultures.

Did you know?

A strange skin disease referred to as Morgellons has occurred in the southern United States and in California. Symptoms include slowly healing sores, joint pain, persistent fatigue, and a sensation of things crawling through the skin. Another symptom is strange-looking, threadlike extrusions coming out of the skin.

Did you know?

There are 60,000 miles of blood vessels in every adult human.

Did you know?

Multiple sclerosis is a condition wherein the body's nervous system is weakened by an autoimmune reaction that attacks the myelin sheaths of neurons.

Did you know?

Many people have small pouches in their colons that bulge outward through weak spots. Each pouch is called a diverticulum. About 10% of Americans older than age 40 years have diverticulosis, which, when the pouches become infected or inflamed, is called diverticulitis. The main cause of diverticular disease is a low-fiber diet.

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
Establishing a caring and trusting relationship helps the client come to terms with a terminal illne Establishing a caring and trusting relationship helps the client come to terms with a terminal illne
The Circle of Relationship Issues and Sexual Problems The Circle of Relationship Issues and Sexual Problems
Relationship of the electrocardiogram to electrical conduction in the heart. Relationship of the electrocardiogram to electrical conduction in the heart.
The relationship between RH and temperature. The relationship between RH and temperature.
E9-23 Prepare income statements Explain the difference in operating income E9-23 Prepare income statements Explain the difference in operating income
Video: Interpreting a cladogram Animation

For a complete list of videos, visit our video library