Register

UGC NET CSE | June 2016 | Part 3 | Question: 12

2,298 views
0 votes
0 votes

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

  1. Only the joining attributes are sent from one site to another and then all of the rows are returned
  2. All of the attributes are sent from one site to another and then only the required rows are returned
  3. Only the joining attributes are sent from one site to another and then only the required rows are returned
  4. All of the attributes are sent from one site to another and then only the required rows are returned
User Avatar

2 Answers

Best answer
1 votes
1 votes
option 3 is the right answer. Please go to the semi join algorithm .
• selected by
User Avatar
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

3.2k
views
1 answers
2 votes
go_editor asked Aug 20, 2016
3,163 views
UGC NET CSE | June 2016 | Part 3 | Question: 54
Suppose that the time to do a null remote procedure call (RPC) (i.e., 0 data bytes) is 1.0 msec with an additional 1.5 msec for every 1K of data. How ... it take to read 32 K from the file server as 32 1K RPCs?49 msec80 msec48 msec100 msec
User Avatar
6.0k
views
1 answers
2 votes
Sanjay Sharma asked Jul 11, 2016
5,972 views
UGC NET CSE | June 2016 | Part 3 | Question: 8
In distributed databases, location transparency allows for database users, programmers and administratirs to treat the data as if it is ... , A SQL query with location transparency needs to specifyInheritancesFragmentsLocationsLocal formats
User Avatar
3.0k
views
1 answers
2 votes
makhdoom ghaya asked Jul 24, 2016
3,027 views
UGC NET CSE | December 2014 | Part 3 | Question: 07
Location transparency allows:I. Users to treat the data as if it is done at one location.II. Programmers to treat the data as if it is at one location.III. Managers to treat the ... $III$ $I$ and $II$ only $II$ and $III$ only$II$ only
User Avatar
1.9k
views
1 answers
0 votes
makhdoom ghaya asked Jun 27, 2016
1,931 views
UGC NET CSE | June 2014 | Part 2 | Question: 27
Object Request Broker (ORB) isI. A software program that runs on the client as well as on the application server.II. A software program that runs on the client side only.III. A software ... I$, $II$ & $III$I$ & $II$ $II$ & $III$ $I$ only
User Avatar
Link Copied!