Q713
Which table is used to run a UNION-type query on MyISAM tables?
A.
TRADITIONAL
B.
MERGE
AnswerC.
SERVELET
D.
UNITE
Answer: Option B
Solution
Answer: Option B
Solution:
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.