« previous next »

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

The U.S. Preventive Services Task Force recommends that all women age 65 years of age or older should be screened with bone densitometry.

Did you know?

Many medications that are used to treat infertility are injected subcutaneously. This is easy to do using the anterior abdomen as the site of injection but avoiding the area directly around the belly button.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

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?

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.

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.
Apply direct pressure under the zygomatic arch. Moving laterally, gently press up and under the ... Apply direct pressure under the zygomatic arch. Moving laterally, gently press up and under the ...
Demographic Data for India Demographic Data for India
Access to Health Plus Mastering Health Access to Health Plus Mastering Health
Find a quadractic equation that models the data in standard form Find a quadractic equation that models the data in standard form
data data
Video: Transferring genes into plants Animation

For a complete list of videos, visit our video library