« previous next »

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

Excessive alcohol use costs the country approximately $235 billion every year.

Did you know?

Earwax has antimicrobial properties that reduce the viability of bacteria and fungus in the human ear.

Did you know?

The most common childhood diseases include croup, chickenpox, ear infections, flu, pneumonia, ringworm, respiratory syncytial virus, scabies, head lice, and asthma.

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

Did you know?

There are more nerve cells in one human brain than there are stars in the Milky Way.

tree-ring data tree-ring data
In a craniotomy, a portion of the skull and overlying scalp is pulled back to allow access to the br In a craniotomy, a portion of the skull and overlying scalp is pulled back to allow access to the br
A gasoline direct-injection (GDI) fuel rail and pump assembly with the electric pressure control ... A gasoline direct-injection (GDI) fuel rail and pump assembly with the electric pressure control ...
Design Data for Various Packings Design Data for Various Packings
Model of how direct repeats generated during the insertion of a transposon or an insertion sequence Model of how direct repeats generated during the insertion of a transposon or an insertion sequence
Data for Calculating Productivity Growth in Erewhon Data for Calculating Productivity Growth in Erewhon
Video: Hormonal regulation of pregnancy - week 1

For a complete list of videos, visit our video library