This topic contains a solution. Click here to go to the answer

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

Brittanyd9008

  • Hero Member
  • *****
  • Posts: 500
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
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


adammoses97

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

 

Did you know?

Fungal nail infections account for up to 30% of all skin infections. They affect 5% of the general population—mostly people over the age of 70.

Did you know?

Oxytocin is recommended only for pregnancies that have a medical reason for inducing labor (such as eclampsia) and is not recommended for elective procedures or for making the birthing process more convenient.

Did you know?

Every flu season is different, and even healthy people can get extremely sick from the flu, as well as spread it to others. The flu season can begin as early as October and last as late as May. Every person over six months of age should get an annual flu vaccine. The vaccine cannot cause you to get influenza, but in some seasons, may not be completely able to prevent you from acquiring influenza due to changes in causative viruses. The viruses in the flu shot are killed—there is no way they can give you the flu. Minor side effects include soreness, redness, or swelling where the shot was given. It is possible to develop a slight fever, and body aches, but these are simply signs that the body is responding to the vaccine and making itself ready to fight off the influenza virus should you come in contact with it.

Did you know?

Although not all of the following muscle groups are commonly used, intramuscular injections may be given into the abdominals, biceps, calves, deltoids, gluteals, laterals, pectorals, quadriceps, trapezoids, and triceps.

Did you know?

Signs and symptoms that may signify an eye tumor include general blurred vision, bulging eye(s), double vision, a sensation of a foreign body in the eye(s), iris defects, limited ability to move the eyelid(s), limited ability to move the eye(s), pain or discomfort in or around the eyes or eyelids, red or pink eyes, white or cloud spots on the eye(s), colored spots on the eyelid(s), swelling around the eyes, swollen eyelid(s), and general vision loss.

For a complete list of videos, visit our video library