Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 669 |
SQL automatically does not eliminate duplicate tuples in the results of queries because
a) In aggregation function duplicates are useful
b) Duplicate elimination is expensive
c) memory chips are cheap and large these days, and can accommodate large number of tuples
Which of the following is/are correct?
a) In aggregation function duplicates are useful
b) Duplicate elimination is expensive
c) memory chips are cheap and large these days, and can accommodate large number of tuples
Which of the following is/are correct?
| a and b | |
| b and c | |
| Only b | |
| Only c |
Question 669 Explanation:
→In order to perform aggregate operations , we need to consider duplicate values also.
→Removing duplication tuple is costly operation in which we need to access all the tuples in order to find the duplicate tuples.
→Removing duplication tuple is costly operation in which we need to access all the tuples in order to find the duplicate tuples.
Correct Answer: A
Question 669 Explanation:
→In order to perform aggregate operations , we need to consider duplicate values also.
→Removing duplication tuple is costly operation in which we need to access all the tuples in order to find the duplicate tuples.
→Removing duplication tuple is costly operation in which we need to access all the tuples in order to find the duplicate tuples.