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

savannahhooper

  • Hero Member
  • *****
  • Posts: 576
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
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
 

Did you know?

Not getting enough sleep can greatly weaken the immune system. Lack of sleep makes you more likely to catch a cold, or more difficult to fight off an infection.

Did you know?

All adults should have their cholesterol levels checked once every 5 years. During 2009–2010, 69.4% of Americans age 20 and older reported having their cholesterol checked within the last five years.

Did you know?

More than 2,500 barbiturates have been synthesized. At the height of their popularity, about 50 were marketed for human use.

Did you know?

It is widely believed that giving a daily oral dose of aspirin to heart attack patients improves their chances of survival because the aspirin blocks the formation of new blood clots.

Did you know?

Asthma cases in Americans are about 75% higher today than they were in 1980.

For a complete list of videos, visit our video library