« previous next »

Author Question: How does a DBMS store data on its direct access files? What will be an ideal ... (Read 171 times)

LaDunn

  • Hero Member
  • *****
  • Posts: 526
on: Jul 7, 2018
How does a DBMS store data on its direct access files?
 
  What will be an ideal response?

Question 2

The presence of one or more foreign keys in a relation prevents ________.
 
  A) the elimination of modification anomalies
  B) the elimination of duplicated data
  C) more complex SQL for multitable subqueries and joins
  D) Both A and B are correct


anyusername12131

  • Sr. Member
  • ****
  • Posts: 327
Reply #1 on: Jul 7, 2018
Answer to Question 1

Usually the DBMS creates large physical records, also called blocks. The physical records are used as containers for logical records. Physical records are addressed by a relative record number (RRN).

Answer to Question 2

B


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Stevens-Johnson syndrome and Toxic Epidermal Necrolysis syndrome are life-threatening reactions that can result in death. Complications include permanent blindness, dry-eye syndrome, lung damage, photophobia, asthma, chronic obstructive pulmonary disease, permanent loss of nail beds, scarring of mucous membranes, arthritis, and chronic fatigue syndrome. Many patients' pores scar shut, causing them to retain heat.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

Always store hazardous household chemicals in their original containers out of reach of children. These include bleach, paint, strippers and products containing turpentine, garden chemicals, oven cleaners, fondue fuels, nail polish, and nail polish remover.

Did you know?

Oliver Wendell Holmes is credited with introducing the words "anesthesia" and "anesthetic" into the English language in 1846.

Did you know?

Atropine, along with scopolamine and hyoscyamine, is found in the Datura stramonium plant, which gives hallucinogenic effects and is also known as locoweed.

Tall pad extensions can also be used to gain access to the frame of a vehicle. This position is ... Tall pad extensions can also be used to gain access to the frame of a vehicle. This position is ...
Apply direct pressure to points along the shoulders. Stand to one side and use your forearm to apply ... Apply direct pressure to points along the shoulders. Stand to one side and use your forearm to apply ...
How to create a frequency table and histogram from raw data How to create a frequency table and histogram from raw data
La Niña events store energy La Niña events store energy
Data management short answer q Data management short answer q
data data
Video: HDL (high density lipoprotein)

For a complete list of videos, visit our video library