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 100 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
Great answer, keep it coming :)

Animal_Goddess

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

« previous next »
 

Did you know?

Coca-Cola originally used coca leaves and caffeine from the African kola nut. It was advertised as a therapeutic agent and "pickerupper." Eventually, its formulation was changed, and the coca leaves were removed because of the effects of regulation on cocaine-related products.

Did you know?

Cucumber slices relieve headaches by tightening blood vessels, reducing blood flow to the area, and relieving pressure.

Did you know?

The top five reasons that children stay home from school are as follows: colds, stomach flu (gastroenteritis), ear infection (otitis media), pink eye (conjunctivitis), and sore throat.

Did you know?

Lower drug doses for elderly patients should be used first, with titrations of the dose as tolerated to prevent unwanted drug-related pharmacodynamic effects.

Did you know?

When taking monoamine oxidase inhibitors, people should avoid a variety of foods, which include alcoholic beverages, bean curd, broad (fava) bean pods, cheese, fish, ginseng, protein extracts, meat, sauerkraut, shrimp paste, soups, and yeast.

Rates of water loss by two turtles and a tortoise indicate an inverse relationship between the dryne Rates of water loss by two turtles and a tortoise indicate an inverse relationship between the dryne
Position of the lungs within the thoracic cavity; anterior view illustrating regions of the lungs an Position of the lungs within the thoracic cavity; anterior view illustrating regions of the lungs an
What are examples of ideal forms? What are examples of ideal forms?
How to determine if a table of values represents a linear or quadratic relationship How to determine if a table of values represents a linear or quadratic relationship
Relationship between inorganic and organic nitrogen metabolism Relationship between inorganic and organic nitrogen metabolism
Explain how it can be desirable from an intertemporal perspective for a country run a current ... Explain how it can be desirable from an intertemporal perspective for a country run a current ...
Video: Dendrite Animation

For a complete list of videos, visit our video library