Home / Programming MCQs / MySQL MCQs / Question

Q. How can a view refer to multiple tables?

(A) SELECT
(B) GROUP
(C) JOIN
(D) UNION

Explanation:

In MySQL, a ‘View’ can refer to multiple tables. This makes it a lot simpler to execute the queries involving joins. When a selection is made from the view, the join is executed producing the results.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.