Database-Management-System
May 3, 20242011 December UGC NET Paper 1
May 3, 2024Database-Management-System
| Question 457 |
Semi-join strategies are techniques for query processing in distributed database system. Which of the following is a semi-join technique ?
| Only the joining attributes are sent from one site to another and then all of the rows are returned. | |
| All of the attributes are sent from one site to another and then only the required rows are returned. | |
| Only the joining attributes are sent from one site to another and then only the required rows are returned. | |
| All of the attributes are sent from one site to another and then only the required rows are returned. |
Question 457 Explanation:
A semi-join returns one copy of each row in the first table for which at least one match is found. Semi-join is like EXCEPT command in SQL.
Correct Answer: C
Question 457 Explanation:
A semi-join returns one copy of each row in the first table for which at least one match is found. Semi-join is like EXCEPT command in SQL.
Subscribe
Login
0 Comments