Inner join returns only the rows that have matching values in both tables. This means that any tuples that don't have a corresponding match in the other table are excluded from the result.
Other Join Types
Left outer join: Preserves all tuples from the left table, even if there are no matches in the right table.
Right outer join: Preserves all tuples from the right table, even if there are no matches in the left table.
Natural join: Similar to inner join, but only considers columns with the same name for matching.
In summary, while outer joins include unmatched tuples in the result, inner join strictly focuses on matching rows and discards any that don't have a corresponding match.
If you think there is any confusion in the given MCQs, you can comment below.
docmcqs.com is Pakistan's No.1 online platform for preparing for all types of exams including PPSC, FPSC, KPSC, SPSC, Ministry of Defence, and for one-paper MCQs. This includes Pedagogy MCQs, general knowledge MCQs, current affairs MCQs, and much more.