adplus-dvertising
frame-decoration

Question

The keyword used with UNION that retains duplicate rows is ___________

a.

ALL

b.

NARROW

c.

STRICT

d.

DISTINCT

Answer: (a).ALL

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. The keyword used with UNION that retains duplicate rows is ___________

Similar Questions

Discover Related MCQs

Q. The search mode that uses natural language search as a subroutine is ____________

Q. For what can the FULLTEXT indexes be created for?

Q. A FULLTEXT index can be created for multiple columns.

Q. For which of these storage engines are configuration options always built?

Q. The storage engine for which the runtime options are always enabled is ______________

Q. The most important configurable resource for MyISAM is ______________

Q. Which system variable enables mysqld to keep more tables open simultaneously?

Q. How can a view refer to multiple tables?

Q. What is the mantissa in -1.58E5?

Q. What is the precision of BIGINT?

Q. How many digits is the DECIMAL used for expressions containing only exact values with fractional part?

Q. The LOCAL capability for LOAD DATA does not need to be enabled explicitly.

Q. The LOCAL capability for client library is enabled by ______________

Q. What is the most important configurable resource for MyISAM?

Q. How many options can be used to control LOCAL capability at runtime?

Q. A multiple-table delete cannot apply any join.

Q. The mode used to turn off the special meaning of backslash and treat it as an ordinary character is _____________

Q. What is x’ffff’ in decimal?

Q. What are X’61626364′ and X’61626364′?

Q. The server sets its default time zone by examining its environment.