A

Admin • 833K Points
Coach

Q. How can a view refer to multiple tables?

  • (A) SELECT
  • (B) GROUP
  • (C) JOIN
  • (D) UNION
  • Correct Answer - Option(C)
  • Views: 20
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

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.

Be the first to start discuss.