« previous next »

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

Certain chemicals, after ingestion, can be converted by the body into cyanide. Most of these chemicals have been removed from the market, but some old nail polish remover, solvents, and plastics manufacturing solutions can contain these substances.

Did you know?

Only 12 hours after an egg cell is fertilized by a sperm cell, the egg cell starts to divide. As it continues to divide, it moves along the fallopian tube toward the uterus at about 1 inch per day.

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?

A cataract is a clouding of the eyes' natural lens. As we age, some clouding of the lens may occur. The first sign of a cataract is usually blurry vision. Although glasses and other visual aids may at first help a person with cataracts, surgery may become inevitable. Cataract surgery is very successful in restoring vision, and it is the most frequently performed surgery in the United States.

Did you know?

Certain rare plants containing cyanide include apricot pits and a type of potato called cassava. Fortunately, only chronic or massive ingestion of any of these plants can lead to serious poisoning.

Model of a longitudinal study in which 983 students were surveyed in 1984 and then again in 1985, 19 Model of a longitudinal study in which 983 students were surveyed in 1984 and then again in 1985, 19
Looking carefully at the scan tool data is very helpful in locating the source of a problem. Looking carefully at the scan tool data is very helpful in locating the source of a problem.
Apply effleurage and direct pressure on attachments of pectoralis minor. Lift one arm off the table ... Apply effleurage and direct pressure on attachments of pectoralis minor. Lift one arm off the table ...
Client files are kept in alphabetical order in locked file cabinets. Client files are kept in alphabetical order in locked file cabinets.
Satellite data on primary productivity in the equatorial Pacific Ocean Satellite data on primary productivity in the equatorial Pacific Ocean
The Hfr chromosome time-of-entry map is assembled from the recombinant data The Hfr chromosome time-of-entry map is assembled from the recombinant data
Video: Junction Types - Tight and Adherens Junctions

For a complete list of videos, visit our video library