5
AssignmentMultiple Select

Designing a Relational Database

Question 5 • DRHS-Business and Tech BLOCK (07.4410030)

Which records would be returned in a query based on an inner join between a table named Customers and a table named Orders? Check all that apply.orphaned ordersorphaned customerscustomers who placed orderscustomers who did not place ordersorders that are attached to customersorders that are not attached to customers

Answer
A
orphaned orders
B
orphaned customers
C
customers who placed orders
D
customers who did not place orders
E
orders that are attached to customers
F
orders that are not attached to customers

Explanation

An inner join returns rows only when a customer record matches an order record through the join condition. Therefore, it includes customers who placed orders and orders that are attached to customers. It excludes orphaned records and customers who did not place orders because those rows have no match in the other table.

AI-written and checked against the verified answer.

Previous
Next