« previous next »

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

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

The B-complex vitamins and vitamin C are not stored in the body and must be replaced each day.

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?

According to the FDA, adverse drug events harmed or killed approximately 1,200,000 people in the United States in the year 2015.

Did you know?

In 1835 it was discovered that a disease of silkworms known as muscardine could be transferred from one silkworm to another, and was caused by a fungus.

Pocket gophers and ecosystem structure (data from Huntly and Inouye 1988). Pocket gophers and ecosystem structure (data from Huntly and Inouye 1988).
Critical thinking involves analysis in which the nurse examines patient data available from a variet Critical thinking involves analysis in which the nurse examines patient data available from a variet
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
Zonal wind speeds on Uranus. Shaded areas show the southern collar and its future northern counterpa Zonal wind speeds on Uranus. Shaded areas show the southern collar and its future northern counterpa
Allows access to the nut that has a stud plus other locations needing great depth, such as spark ... Allows access to the nut that has a stud plus other locations needing great depth, such as spark ...
Data for a Hypothetical Paternity Test Using 13 CODIS Genes Data for a Hypothetical Paternity Test Using 13 CODIS Genes
Video: Pneumonia Animation

For a complete list of videos, visit our video library