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

Warfarin was developed as a consequence of the study of a strange bleeding disorder that suddenly occurred in cattle on the northern prairies of the United States in the early 1900s.

Did you know?

Today, nearly 8 out of 10 pregnant women living with HIV (about 1.1 million), receive antiretrovirals.

Did you know?

In most cases, kidneys can recover from almost complete loss of function, such as in acute kidney (renal) failure.

Did you know?

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Did you know?

Human neurons are so small that they require a microscope in order to be seen. However, some neurons can be up to 3 feet long, such as those that extend from the spinal cord to the toes.

For a complete list of videos, visit our video library