Register

NPTEL

406 views
0 votes
0 votes
Consider the following pair of operations and the associated list of techniques.

Deduplication: Hashing
Difference: Hashing, Sorting
Full Outer Join: Block Nested join, Index-Nested join
Left-Outer Join: Hash join, Index-Nested join

Which of these operations can be implemented using all the techniques mentioned in the corresponding list?

1.Only deduplication, full outer join and left-outer join
 
2. Only deduplication
 
3. Only deduplication and full outer join
 
4. Only difference and full outer join
User Avatar

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
3
Bhupendra asked Jan 4, 2019
375 views
dbms nptel
Q6:Which of the following statements are not true? A. Superset of a superkey is also a superkey. B. Superset of a candidate key is a superkey. C. Subset of a candidate key can be a superkey. D. Proper subset of a candidate key is also a candidate key
Q6:Which of the following statements are not true?A. Superset of a superkey is also a superkey.B. Superset of a candidate key is a superkey.C. Subset of a candidate key c...
User Avatar
0 votes
0 votes
0 answers
4
BASANT KUMAR asked Sep 30, 2018
323 views
nptel(self doubt)
statement -1: concurrent schedule which is equivalent to some serial schedule is said to be concurrent serializable schedule. statement 2:concurrent schedule which is not concurrent serializable schedule may be consistent. correct statement is ?? i know statement (1) is correct what about statement(2)???
statement -1: concurrent schedule which is equivalent to some serial schedule is said to be concurrent serializable schedule.statement 2:concurrent schedule which is not ...
User Avatar
Link Copied!