« previous next »

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

There are approximately 3 million unintended pregnancies in the United States each year.

Did you know?

About 3.2 billion people, nearly half the world population, are at risk for malaria. In 2015, there are about 214 million malaria cases and an estimated 438,000 malaria deaths.

Did you know?

There are immediate benefits of chiropractic adjustments that are visible via magnetic resonance imaging (MRI). It shows that spinal manipulation therapy is effective in decreasing pain and increasing the gaps between the vertebrae, reducing pressure that leads to pain.

Did you know?

Computer programs are available that crosscheck a new drug's possible trade name with all other trade names currently available. These programs detect dangerous similarities between names and alert the manufacturer of the drug.

Did you know?

There are more bacteria in your mouth than there are people in the world.

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
For the 2-year-old, encounters with peers provide valuable practice in communication and social ... For the 2-year-old, encounters with peers provide valuable practice in communication and social ...
Cultures Ideal Body Types Cultures Ideal Body Types
Sample root cause analysis: Duplicate dose of a narcotic analgesic. Sample root cause analysis: Duplicate dose of a narcotic analgesic.
The bimetallic temperature sensor spring controls the amount of silicone that is allowed into the ... The bimetallic temperature sensor spring controls the amount of silicone that is allowed into the ...
Foundations of evidence-based practice. Foundations of evidence-based practice.
Video: Hormonal regulation of pregnancy - weeks 2 through 38

For a complete list of videos, visit our video library