« previous next »

Author Question: In practice, why would tables that have duplicate rows be allowed? What will be an ideal ... (Read 16 times)

savannahhooper

  • Hero Member
  • *****
  • Posts: 576
on: Jul 7, 2018
In practice, why would tables that have duplicate rows be allowed?
 
  What will be an ideal response?

Question 2

________ is an important business function whose purpose is to manage the database to maximize its value to the organization.
 
  Fill in the blank(s) with correct word


josephsuarez

  • Sr. Member
  • ****
  • Posts: 323
Reply #1 on: Jul 7, 2018
Answer to Question 1

It is not uncommon for a table that is returned as the result of a data manipulation operation, such as a query, to contain duplicate rows. This is often tolerated because of the processing time necessary for the DBMS to search the table to find and eliminate duplicate rows. This is especially true if the table is very large. In these cases, it is often acceptable to allow the duplicate rows to exist.

Answer to Question 2

Database administration


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Human stomach acid is strong enough to dissolve small pieces of metal such as razor blades or staples.

Did you know?

In the ancient and medieval periods, dysentery killed about ? of all babies before they reach 12 months of age. The disease was transferred through contaminated drinking water, because there was no way to adequately dispose of sewage, which contaminated the water.

Did you know?

Patients who have been on total parenteral nutrition for more than a few days may need to have foods gradually reintroduced to give the digestive tract time to start working again.

Did you know?

Children with strabismus (crossed eyes) can be treated. They are not able to outgrow this condition on their own, but with help, it can be more easily corrected at a younger age. It is important for infants to have eye examinations as early as possible in their development and then another at age 2 years.

Did you know?

Illicit drug use costs the United States approximately $181 billion every year.

A subculture of employees who work at a medical practice A subculture of employees who work at a medical practice
The family of a soldier in the 31st Philadelphia Infantry camps near Washington, DC. Although both a The family of a soldier in the 31st Philadelphia Infantry camps near Washington, DC. Although both a
Typical components of software for a practice management system (PMS). Typical components of software for a practice management system (PMS).
Medication with the USP label (left) and without USP label (right). Practice Label “for ... Medication with the USP label (left) and without USP label (right). Practice Label “for ...
The bimetallic temperature sensor spring controls the amount of silicone that is allowed into the ... The bimetallic temperature sensor spring controls the amount of silicone that is allowed into the ...
An intake manifold gasket that failed and allowed coolant to be drawn into the cylinder(s). An intake manifold gasket that failed and allowed coolant to be drawn into the cylinder(s).
Video: Import of Dietary Glucose from Intestines to Bloodstream

For a complete list of videos, visit our video library