Question 674 – Database-Management-System
May 14, 2024ER-Model
May 14, 2024Database-Management-System
|
Question 823
|
In RDBMS, which type of Join returns all rows that satisfy the join condition ?
|
Inner Join
|
|
|
Outer Join
|
|
|
Semi Join
|
|
|
Anti Join
|
Question 823 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.
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 823 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.
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.