« previous next »

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

After 5 years of being diagnosed with rheumatoid arthritis, one every three patients will no longer be able to work.

Did you know?

There are immediate benefits of chiropractic adjustments that are visible via magnetic resonance imaging (MRI). It shows that spinal manipulation therapy is effective in decreasing pain and increasing the gaps between the vertebrae, reducing pressure that leads to pain.

Did you know?

Eating carrots will improve your eyesight. Carrots are high in vitamin A (retinol), which is essential for good vision. It can also be found in milk, cheese, egg yolks, and liver.

Did you know?

To maintain good kidney function, you should drink at least 3 quarts of water daily. Water dilutes urine and helps prevent concentrations of salts and minerals that can lead to kidney stone formation. Chronic dehydration is a major contributor to the development of kidney stones.

Did you know?

Less than one of every three adults with high LDL cholesterol has the condition under control. Only 48.1% with the condition are being treated for it.

Direct Immunoassays Direct Immunoassays
Apply direct pressure along upper trapezius, turning the head to access the area. Use your thumb to ... Apply direct pressure along upper trapezius, turning the head to access the area. Use your thumb to ...
Direct percussion Direct percussion
If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas? If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas?
For the circuit in Figure 1, assume ideal diodes. The peak inverse voltage is approximately For the circuit in Figure 1, assume ideal diodes. The peak inverse voltage is approximately
Satellite data on primary productivity in the equatorial Pacific Ocean Satellite data on primary productivity in the equatorial Pacific Ocean
Video: Male Reproductive System - The gonadotropin releasing hormone

For a complete list of videos, visit our video library