« previous next »

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

Children of people with alcoholism are more inclined to drink alcohol or use hard drugs. In fact, they are 400 times more likely to use hard drugs than those who do not have a family history of alcohol addiction.

Did you know?

The B-complex vitamins and vitamin C are not stored in the body and must be replaced each day.

Did you know?

Intradermal injections are somewhat difficult to correctly administer because the skin layers are so thin that it is easy to accidentally punch through to the deeper subcutaneous layer.

Did you know?

Immunoglobulin injections may give short-term protection against, or reduce severity of certain diseases. They help people who have an inherited problem making their own antibodies, or those who are having certain types of cancer treatments.

Did you know?

Anti-aging claims should not ever be believed. There is no supplement, medication, or any other substance that has been proven to slow or stop the aging process.

Summary of US Census Data Summary of US Census Data
A typical OBD-II data link connector (DLC). The location varies with make and model and may even be ... A typical OBD-II data link connector (DLC). The location varies with make and model and may even be ...
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 ...
Fingertip rake over pectoralis major from sternum to shoulder. Pull arm out from the body to access ... Fingertip rake over pectoralis major from sternum to shoulder. Pull arm out from the body to access ...
La Niña events store energy La Niña events store energy
Type III curve. Mortality is highest early in life. Data for a desert shrub (Cleome droserifolia). Type III curve. Mortality is highest early in life. Data for a desert shrub (Cleome droserifolia).
Video: Cellular Defects - Osteoblasts, Osteoclasts and Osteocytes

For a complete list of videos, visit our video library