UTpaper

Free mock tests & test series

Question 60Asked in UGC NET Computer Science, June 2016 (Paper II & III, Selected Questions)

Semi-join strategies are techniques for query processing in distributed database system. Which of the following is a semi-join technique?

  1. AOnly the joining attributes are sent from one site to another and then all of the rows are returned
  2. BAll of the attributes are sent from one site to another and then only the required rows are returned
  3. COnly the joining attributes are sent from site to another and then only the required rows are returned
  4. DAll of the attributes are sent from one site to another and then only the required rows are returned.
Show answerHide answer

Correct answer: (C) Only the joining attributes are sent from site to another and then only the required rows are returned

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.

From UGC NET Computer Science PYQ, June 2016 (Paper II & III, Selected Questions)

This is question 60 of UGC NET Computer Science PYQ, June 2016 (Paper II & III, Selected Questions). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.