« previous next »

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

In the United States, an estimated 50 million unnecessary antibiotics are prescribed for viral respiratory infections.

Did you know?

Patients who have undergone chemotherapy for the treatment of cancer often complain of a lack of mental focus; memory loss; and a general diminution in abilities such as multitasking, attention span, and general mental agility.

Did you know?

About 100 new prescription or over-the-counter drugs come into the U.S. market every year.

Did you know?

The types of cancer that alpha interferons are used to treat include hairy cell leukemia, melanoma, follicular non-Hodgkin's lymphoma, and AIDS-related Kaposi's sarcoma.

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

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
Wetlands Store and Clean Water Wetlands Store and Clean Water
Cross-sectional data showing that the amount of effort spent on personal health care increases with Cross-sectional data showing that the amount of effort spent on personal health care increases with
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
La Niña events store energy La Niña events store energy
A very light ideal spring stretches by when it is used to hang a 135-N object. What is the ... A very light ideal spring stretches by when it is used to hang a 135-N object. What is the ...
Video: How Hemoglobin Picks Up and Delivers Oxygen

For a complete list of videos, visit our video library