« previous next »

Author Question: How does a DBMS store data on its direct access files? What will be an ideal ... (Read 168 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. Pharmacopeia Medication Errors Reporting Program states that approximately 50% of all medication errors involve insulin.

Did you know?

Asthma occurs in one in 11 children and in one in 12 adults. African Americans and Latinos have a higher risk for developing asthma than other groups.

Did you know?

Acute bronchitis is an inflammation of the breathing tubes (bronchi), which causes increased mucus production and other changes. It is usually caused by bacteria or viruses, can be serious in people who have pulmonary or cardiac diseases, and can lead to pneumonia.

Did you know?

The average human gut is home to perhaps 500 to 1,000 different species of bacteria.

Did you know?

Elderly adults are living longer, and causes of death are shifting. At the same time, autopsy rates are at or near their lowest in history.

Herniated disk. A herniated disk is a protrusion of the disk’s gelatinous center, called the nucleus Herniated disk. A herniated disk is a protrusion of the disk’s gelatinous center, called the nucleus
There may become a driveability issue because the gasoline direct-injection injector is exposed to ... There may become a driveability issue because the gasoline direct-injection injector is exposed to ...
The data link connector (DLC) can be located in various locations. The data link connector (DLC) can be located in various locations.
Dorsiflex the foot, applying direct pressure to the bottom. Standing at the end of the table, pick ... Dorsiflex the foot, applying direct pressure to the bottom. Standing at the end of the table, pick ...
Direct acting of antispasmodic drugs Direct acting of antispasmodic drugs
Histograms - Analysis and Data Histograms - Analysis and Data
Video: Hormonal feedback loop components & Glucagon (glycogenolysis and gluconeogenesis)

For a complete list of videos, visit our video library