Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
Question 577 |
In RDBMS, which type of Join returns all rows that satisfy the join condition ?
Inner Join | |
Outer Join | |
Semi Join | |
Anti Join |
Question 577 Explanation:
Inner Join : Inner join combines two tables having a common attributes. While combining it only join the rows of two tables having same value in common attribute. So in that way inner join return the records having matching values in both the tables.
Correct Answer: A
Question 577 Explanation:
Inner Join : Inner join combines two tables having a common attributes. While combining it only join the rows of two tables having same value in common attribute. So in that way inner join return the records having matching values in both the tables.