A view can refer to multiple tables via . . . . . . . .
A. UNION
B. JOIN
C. GROUP
D. SELECT
Answer: Option B
Solution (By Examveda Team)
This question is asking about how views in MySQL can access data from multiple tables.Let's break it down:
* Views are like virtual tables that don't actually store data. They just present a specific way to look at data from real tables.
* UNION combines results from different queries, but it's not the way a view references multiple tables.
* JOIN is the key here! A JOIN combines data from two or more tables based on a shared column. Views can use JOIN to bring data from multiple tables into a single view.
* GROUP is used for summarizing data within a table, not for combining tables.
* SELECT is a basic operation for retrieving data, but not for creating a view that references multiple tables.
Therefore, the correct answer is Option B: JOIN.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network

Join The Discussion