Which table is used to run a UNION-type query on MyISAM tables?
A. TRADITIONAL
B. MERGE
C. SERVELET
D. UNITE
Answer: Option B
Solution (By Examveda Team)
This question is asking about a special type of table in MySQL that lets you combine results from multiple tables. Think of it like merging two lists into one!Here's the breakdown of the options:
Option A: TRADITIONAL - This refers to a traditional storage engine in MySQL, not specifically for combining tables.
Option B: MERGE - This is the correct answer! A MERGE table is a special type of table that combines results from multiple MyISAM tables.
Option C: SERVELET - This is a Java technology and has nothing to do with MySQL.
Option D: UNITE - This is not a valid option in MySQL.
So, the answer is Option B: MERGE.
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