Which term describes a type of join that includes only records common to both sides of a join?

Which term describes a type of join that includes only records common to both sides of a join?

• A. Instance
• B. IFrame
• C. Inner Join
• D. Index

Answer: (C)

Inner join returns only records that have a match in both tables, effectively the intersection of the two datasets based on the join condition. This means you’ll see rows only where the joining key exists on both sides, which is why it’s the term that describes a join including only common records. For example, joining customers with orders on customer_id will show only customers who have placed orders. If you wanted all customers regardless of orders, you’d use a left join; if you wanted all records from both sides, you’d use a full outer join. The other terms listed aren’t about how rows are matched: instance, IFrame, and index refer to unrelated concepts.

Inner join returns only records that have a match in both tables, effectively the intersection of the two datasets based on the join condition. This means you’ll see rows only where the joining key exists on both sides, which is why it’s the term that describes a join including only common records. For example, joining customers with orders on customer_id will show only customers who have placed orders. If you wanted all customers regardless of orders, you’d use a left join; if you wanted all records from both sides, you’d use a full outer join. The other terms listed aren’t about how rows are matched: instance, IFrame, and index refer to unrelated concepts.