« previous next »

Author Question: In practice, why would tables that have duplicate rows be allowed? What will be an ideal ... (Read 49 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?

The lipid bilayer is made of phospholipids. They are arranged in a double layer because one of their ends is attracted to water while the other is repelled by water.

Did you know?

There are 20 feet of blood vessels in each square inch of human skin.

Did you know?

Congestive heart failure is a serious disorder that carries a reduced life expectancy. Heart failure is usually a chronic illness, and it may worsen with infection or other physical stressors.

Did you know?

Side effects from substance abuse include nausea, dehydration, reduced productivitiy, and dependence. Though these effects usually worsen over time, the constant need for the substance often overcomes rational thinking.

Did you know?

When blood is exposed to air, it clots. Heparin allows the blood to come in direct contact with air without clotting.

Evidence-based practice: skin assessment Evidence-based practice: skin assessment
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).
Effects of Retrieval Practice on Predicted and Actual Memory Performance Effects of Retrieval Practice on Predicted and Actual Memory Performance
The net price of an article is $79.84. What is the list price if a discount of 23% was allowed? The net price of an article is $79.84. What is the list price if a discount of 23% was allowed?
Compute the rate of discount allowed on a rotor-tiller that lists for $341.00 and is sold for ... Compute the rate of discount allowed on a rotor-tiller that lists for $341.00 and is sold for ...
The fates of duplicate genes The fates of duplicate genes
Video: Generalized life cycles for plants and animals Animation

For a complete list of videos, visit our video library