July2016 cs Q12
- 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.
- Option : 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.
