Database-Management-System
May 3, 20242011 December UGC NET Paper 1
May 3, 2024Database-Management-System
|
Question 457
|
Semi-join strategies are techniques for query processing in distributed database system. Which of the following is a semi-join technique ?
|
Only the joining attributes are sent from one site to another and then all of the rows are returned.
|
|
|
All of the attributes are sent from one site to another and then only the required rows are returned.
|
|
|
Only the joining attributes are sent from one site to another and then only the required rows are returned.
|
|
|
All of the attributes are sent from one site to another and then only the required rows are returned.
|
Question 457 Explanation:
A semi-join returns one copy of each row in the first table for which at least one match is found. Semi-join is like EXCEPT command in SQL.
Correct Answer: C
Question 457 Explanation:
A semi-join returns one copy of each row in the first table for which at least one match is found. Semi-join is like EXCEPT command in SQL.