« previous next »

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

No drugs are available to relieve parathyroid disease. Parathyroid disease is caused by a parathyroid tumor, and it needs to be removed by surgery.

Did you know?

Certain topical medications such as clotrimazole and betamethasone are not approved for use in children younger than 12 years of age. They must be used very cautiously, as directed by a doctor, to treat any child. Children have a much greater response to topical steroid medications.

Did you know?

The Romans did not use numerals to indicate fractions but instead used words to indicate parts of a whole.

Did you know?

The first-known contraceptive was crocodile dung, used in Egypt in 2000 BC. Condoms were also reportedly used, made of animal bladders or intestines.

Did you know?

Always store hazardous household chemicals in their original containers out of reach of children. These include bleach, paint, strippers and products containing turpentine, garden chemicals, oven cleaners, fondue fuels, nail polish, and nail polish remover.

Needle-nose pliers are used where there is limited access to a wire or pin that needs to be ... Needle-nose pliers are used where there is limited access to a wire or pin that needs to be ...
Removing the bed from a pickup truck makes gaining access to the fuel pump a lot easier. Removing the bed from a pickup truck makes gaining access to the fuel pump a lot easier.
Apply direct pressure to points on low back. Press into paraspinal muscles from the side. Move spot ... Apply direct pressure to points on low back. Press into paraspinal muscles from the side. Move spot ...
Effleurage to adductor muscles. Bend the knee and open the leg to access adductor muscles. Resecure ... Effleurage to adductor muscles. Bend the knee and open the leg to access adductor muscles. Resecure ...
data data
Histograms - Analysis and Data Histograms - Analysis and Data
Video: Virtual Enzyme Kinetics & Lineweaver Burk Plot

For a complete list of videos, visit our video library