« previous next »

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

Despite claims by manufacturers, the supplement known as Ginkgo biloba was shown in a study of more than 3,000 participants to be ineffective in reducing development of dementia and Alzheimer’s disease in older people.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

Colchicine is a highly poisonous alkaloid originally extracted from a type of saffron plant that is used mainly to treat gout.

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?

According to the CDC, approximately 31.7% of the U.S. population has high low-density lipoprotein (LDL) or "bad cholesterol" levels.

Direct Fist Percussion of Left Kidney Direct Fist Percussion of Left Kidney
Mechanism of Action of Direct-Acting Antispasmodics Mechanism of Action of Direct-Acting Antispasmodics
Women who are monozygotic twins and have the same genes are more similar in their marital happiness Women who are monozygotic twins and have the same genes are more similar in their marital happiness
Air-Temperature Data Air-Temperature Data
Demographic Data for Nigeria Demographic Data for Nigeria
Sturtevant’s Recombination Data for Five X-Linked Genes in Drosophila Sturtevant’s Recombination Data for Five X-Linked Genes in Drosophila
Video: Glucagon (glycogenolysis and gluconeogenesis)

For a complete list of videos, visit our video library