« previous next »

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

Medications that are definitely not safe to take when breastfeeding include radioactive drugs, antimetabolites, some cancer (chemotherapy) agents, bromocriptine, ergotamine, methotrexate, and cyclosporine.

Did you know?

The training of an anesthesiologist typically requires four years of college, 4 years of medical school, 1 year of internship, and 3 years of residency.

Did you know?

Long-term mental and physical effects from substance abuse include: paranoia, psychosis, immune deficiencies, and organ damage.

Did you know?

In women, pharmacodynamic differences include increased sensitivity to (and increased effectiveness of) beta-blockers, opioids, selective serotonin reuptake inhibitors, and typical antipsychotics.

Did you know?

Essential fatty acids have been shown to be effective against ulcers, asthma, dental cavities, and skin disorders such as acne.

Lavoisier's pioneering direct calorimetry method of measuring BMR. Lavoisier's pioneering direct calorimetry method of measuring BMR.
2006 Data:Top 25 Substances Involved in Human Exposures 2006 Data:Top 25 Substances Involved in Human Exposures
Dorsiflex the foot, applying direct pressure to the bottom. Standing at the end of the table, pick ... Dorsiflex the foot, applying direct pressure to the bottom. Standing at the end of the table, pick ...
Direct thumb pressure to a trigger point. Direct thumb pressure to a trigger point.
Data for Calculating Productivity Growth in Erewhon Data for Calculating Productivity Growth in Erewhon
Data management questions Data management questions
Video: Mechanisms of capillary exchange (transcytosis & bulk flow)

For a complete list of videos, visit our video library