Vidyalelo
MySQL · Q713

MySQL

Programming · MySQL · question 713

Q713

Which table is used to run a UNION-type query on MyISAM tables?

A.
TRADITIONAL
B.
MERGE
Answer
C.
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.