Examveda

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous