Discussion
A semijoin is which of the following?
Answer: C
Correct answer: Only the joining attributes are sent from one site to another and then only the required rows are returned.
The semijoin sends only the joining column values across the network, the remote site matches them against its own rows, and only the rows that actually participate come back. Both halves of the saving matter: fewer columns go out and fewer rows come back, which is why the technique is used where network cost dominates.
No comment is present. Be the first to comment.
Loading…
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development