Author Question: What is a hashing algorithm, and how is it used in hashed file organizations? What will be an ... (Read 34 times)

mspears3

  • Hero Member
  • *****
  • Posts: 586
What is a hashing algorithm, and how is it used in hashed file organizations?
 
  What will be an ideal response?

Question 2

EXISTS takes a value of false if the subquery returns an intermediate result set.
 
  Indicate whether the statement is true or false


steff9894

  • Sr. Member
  • ****
  • Posts: 337
Answer to Question 1

A hashing algorithm is a routine which converts a primary key value into a record address. Hashing algorithms are typically mathematical routines which perform computations such as dividing a primary key by a prime number and then using the remainder for a storage location. The hashing algorithm is used in a file organization to determine where to store the record. One limitation of this is that only one key value can be used for an index.

Answer to Question 2

FALSE



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

GI conditions that will keep you out of the U.S. armed services include ulcers, varices, fistulas, esophagitis, gastritis, congenital abnormalities, inflammatory bowel disease, enteritis, colitis, proctitis, duodenal diverticula, malabsorption syndromes, hepatitis, cirrhosis, cysts, abscesses, pancreatitis, polyps, certain hemorrhoids, splenomegaly, hernias, recent abdominal surgery, GI bypass or stomach stapling, and artificial GI openings.

Did you know?

Long-term mental and physical effects from substance abuse include: paranoia, psychosis, immune deficiencies, and organ damage.

Did you know?

Though methadone is often used to treat dependency on other opioids, the drug itself can be abused. Crushing or snorting methadone can achieve the opiate "rush" desired by addicts. Improper use such as these can lead to a dangerous dependency on methadone. This drug now accounts for nearly one-third of opioid-related deaths.

Did you know?

In 1844, Charles Goodyear obtained the first patent for a rubber condom.

Did you know?

Pink eye is a term that refers to conjunctivitis, which is inflammation of the thin, clear membrane (conjunctiva) over the white part of the eye (sclera). It may be triggered by a virus, bacteria, or foreign body in the eye. Antibiotic eye drops alleviate bacterial conjunctivitis, and antihistamine allergy pills or eye drops help control allergic conjunctivitis symptoms.

For a complete list of videos, visit our video library