« previous next »

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

About 600,000 particles of skin are shed every hour by each human. If you live to age 70 years, you have shed 105 pounds of dead skin.

Did you know?

The first war in which wide-scale use of anesthetics occurred was the Civil War, and 80% of all wounds were in the extremities.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

If you use artificial sweeteners, such as cyclamates, your eyes may be more sensitive to light. Other factors that will make your eyes more sensitive to light include use of antibiotics, oral contraceptives, hypertension medications, diuretics, and antidiabetic medications.

Did you know?

The Romans did not use numerals to indicate fractions but instead used words to indicate parts of a whole.

Daniel Burnham’s Flatiron Building (1902) was one of the first to use steel girders to hold up the b Daniel Burnham’s Flatiron Building (1902) was one of the first to use steel girders to hold up the b
Sample root cause analysis: Duplicate dose of a narcotic analgesic. Sample root cause analysis: Duplicate dose of a narcotic analgesic.
Private practice setting. Private practice setting.
Foundations of evidence-based practice. Foundations of evidence-based practice.
Private Practice Massage Therapy Business Plan Cont Private Practice Massage Therapy Business Plan Cont
Economic practice question Economic practice question
Video: Passive Smoke Exposure

For a complete list of videos, visit our video library