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

People who have myopia, or nearsightedness, are not able to see objects at a distance but only up close. It occurs when the cornea is either curved too steeply, the eye is too long, or both. This condition is progressive and worsens with time. More than 100 million people in the United States are nearsighted, but only 20% of those are born with the condition. Diet, eye exercise, drug therapy, and corrective lenses can all help manage nearsightedness.

Did you know?

The average office desk has 400 times more bacteria on it than a toilet.

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?

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?

Carbamazepine can interfere with the results of home pregnancy tests. If you are taking carbamazepine, do not try to test for pregnancy at home.

For a complete list of videos, visit our video library