Site navigation

Which of the following queries finds the clients of banker xyz and the city they live in ?

The query must select banker xyz, join Client and Customer on their customer_name fields, and then project the customer name and city. The expression containing…

Choose your answer

Which of the following queries finds the clients of banker xyz and the city they live in ?

Select one answer
Answer and explanation

Correct answer A

The query must select banker xyz, join Client and Customer on their customer_name fields, and then project the customer name and city. The expression containing client.customer_name = customer.customer_name includes the required join predicate; the alternatives without it leave unrelated rows in the Cartesian product.

Practice for these exams

  • Rajasthan Programmer

Related question papers

Related questions in this topic