Which term refers to a type of join where only records that are common to both sides of a join appear in the result set?

Which term refers to a type of join where only records that are common to both sides of a join appear in the result set?

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

Answer: (C)

When you combine two datasets, the term for returning only the rows that have matching values in both sides is an inner join. It yields the intersection of the two tables based on the join condition, so only records that have a corresponding match in both tables appear in the result. For example, joining a Customers table and an Orders table on customer_id returns only customers who have placed orders, excluding customers with no orders and any orders that don’t have a matching customer. Other terms listed don’t describe a join: instantiation and instance relate to object creation in programming, not to how data is combined. IFrame is an HTML element used to embed another page, which is unrelated to database joins.

When you combine two datasets, the term for returning only the rows that have matching values in both sides is an inner join. It yields the intersection of the two tables based on the join condition, so only records that have a corresponding match in both tables appear in the result. For example, joining a Customers table and an Orders table on customer_id returns only customers who have placed orders, excluding customers with no orders and any orders that don’t have a matching customer.

Other terms listed don’t describe a join: instantiation and instance relate to object creation in programming, not to how data is combined. IFrame is an HTML element used to embed another page, which is unrelated to database joins.