adplus-dvertising
frame-decoration

Question

Issuing ‘SELECT’ on a MERGE table is like _____________

a.

UNION

b.

UNION ALL

c.

UNION DISTINCT

d.

JOIN

Posted under MySQL Database

Answer: (b).UNION ALL

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Issuing ‘SELECT’ on a MERGE table is like _____________

Similar Questions

Discover Related MCQs

Q. In Perl DBI, functions are called ______________

Q. Which variable is used as a handle to an open file?

Q. The variable that is a handle to a database object is ______________

Q. Which variable returns code from operations that return true or false?

Q. The statement to remove indexes on tables is ______________

Q. What allows nesting one select statement into another?

Q. The operator that does not perform relative-value comparisons is ______________

Q. The key declares that an index in one table is related to that in another is called _____________

Q. Foreign keys can handle deletes and updates.

Q. The generic handle whose meaning depends on context is ______________

Q. The non handle array representing a row of values is ______________

Q. The return value from operations returning a row count is ______________

Q. While using DBI API functions are called and pointers to structures are used.

Q. Which mode of search is the search string parsed into words and the search looks for rows?

Q. The indicator of presence/absence of a word in search is used in the mode ______________

Q. The numbers that are prefixed with ‘0x’ are in base __________

Q. Hexadecimal numbers can be used in scientific notation.

Q. What is the escape sequence for carriage return?

Q. What is the datatype for single precision floating point number?

Q. RTF refers to ______________