« previous next »

Author Question: How does a DBMS store data on its direct access files? What will be an ideal ... (Read 80 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?

Liver spots have nothing whatsoever to do with the liver. They are a type of freckles commonly seen in older adults who have been out in the sun without sufficient sunscreen.

Did you know?

Only one in 10 cancer deaths is caused by the primary tumor. The vast majority of cancer mortality is caused by cells breaking away from the main tumor and metastasizing to other parts of the body, such as the brain, bones, or liver.

Did you know?

Hip fractures are the most serious consequences of osteoporosis. The incidence of hip fractures increases with each decade among patients in their 60s to patients in their 90s for both women and men of all populations. Men and women older than 80 years of age show the highest incidence of hip fractures.

Did you know?

Nearly all drugs pass into human breast milk. How often a drug is taken influences the amount of drug that will pass into the milk. Medications taken 30 to 60 minutes before breastfeeding are likely to be at peak blood levels when the baby is nursing.

Did you know?

A good example of polar molecules can be understood when trying to make a cake. If water and oil are required, they will not mix together. If you put them into a measuring cup, the oil will rise to the top while the water remains on the bottom.

Thyroid scan. The right image is the data from a thyroid scan, printed on a superimposed map of the Thyroid scan. The right image is the data from a thyroid scan, printed on a superimposed map of the
Young adults increase in self-esteem between the ages of 18 and 25, according to this longitudinal s Young adults increase in self-esteem between the ages of 18 and 25, according to this longitudinal s
Removing the bed from a pickup truck makes gaining access to the fuel pump a lot easier. Removing the bed from a pickup truck makes gaining access to the fuel pump a lot easier.
Hubbard’s Predication of Peak in U.S Oil Production with Actual Data Hubbard’s Predication of Peak in U.S Oil Production with Actual Data
Store vitamin B–rich whole-wheat flour in an airtight container in your refrigerator or freezer Store vitamin B–rich whole-wheat flour in an airtight container in your refrigerator or freezer
Direct Development vs. Incomplete Metamorphosis Direct Development vs. Incomplete Metamorphosis
Video: Chemical Synapse Animation

For a complete list of videos, visit our video library