« previous next »

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

All adverse reactions are commonly charted in red ink in the patient's record and usually are noted on the front of the chart. Failure to follow correct documentation procedures may result in malpractice lawsuits.

Did you know?

The most common treatment options for addiction include psychotherapy, support groups, and individual counseling.

Did you know?

Oliver Wendell Holmes is credited with introducing the words "anesthesia" and "anesthetic" into the English language in 1846.

Did you know?

Pubic lice (crabs) are usually spread through sexual contact. You cannot catch them by using a public toilet.

Did you know?

All patients with hyperparathyroidism will develop osteoporosis. The parathyroid glands maintain blood calcium within the normal range. All patients with this disease will continue to lose calcium from their bones every day, and there is no way to prevent the development of osteoporosis as a result.

2006 Data:Top 25 Substances Involved in Human Exposures 2006 Data:Top 25 Substances Involved in Human Exposures
Graphing Psychological Data Graphing Psychological Data
Data from more than 22,000 men over the age of 40, showing the relationship between birth weight and ... Data from more than 22,000 men over the age of 40, showing the relationship between birth weight and ...
Electronic service information is available from aftermarket sources, such as All-Data and ... Electronic service information is available from aftermarket sources, such as All-Data and ...
A 16-input multiplexer is to be used to perform parallel-to-serial data conversion. Which of ... A 16-input multiplexer is to be used to perform parallel-to-serial data conversion. Which of ...
Data for a Hypothetical Paternity Test Using 13 CODIS Genes Data for a Hypothetical Paternity Test Using 13 CODIS Genes
Video: Glomerubular filtrate rate -pressures that affect GFR and net filtration pressure

For a complete list of videos, visit our video library