UGC-NET | UGC NET CS 2016 July – III | Question 12

Semi-join strategies are techniques for query processing in distributed database system.
Which of the following is a semi-join technique ?
(A) Only the joining attributes are sent from one site to another and then all of the rows are returned.
(B) All of the attributes are sent from one site to another and then only the required rows are returned.
(C) Only the joining attributes are sent from one site to another and then only the required rows are returned.
(D) All of the attributes are sent from one site to another and then only the required rows are returned.


Answer: (C)

Explanation: Semi-join strategies are techniques for query processing in distributed database system. In which only the joining attributes are sent from one site to another and then only the required rows are returned.
So, option (C) is correct.

Quiz of this Question



My Personal Notes arrow_drop_up