Question

The keyword used with UNION that does not retain duplicate rows is _____________

a.

ALL

b.

NARROW

c.

STRICT

d.

DISTINCT

Posted under MySQL Database

Answer: (d).DISTINCT

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 does not retain duplicate rows is _____________

Add Comment

Similar Questions

Discover Related MCQs

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

View solution

Q. The log that contains a record of server startups and shutdowns and the messages about exceptional conditions is ______________

View solution

Q. The log that identifies statements that may be in need of being rewritten for better performance is ______________

View solution

Q. The default value in seconds in the system variable ‘long_query_time’ is ______________

View solution

Q. The logging option to enable binary log index file is ______________

View solution

Q. Usage of aggregates in WHERE clause is not allowed.

View solution

Q. The operators that are used when a subquery returns multiple rows to be evaluated in comparison to the outer query are _____________

View solution

Q. The ALL subquery performs operations on _____________

View solution

Q. What is the kind of delete when deletion of an employee from the table also deletes that employee from another table?

View solution

Q. The storage engine in MySQL that provides foreign key support is ___________

View solution

Q. What is the property of InnoDB that enforces foreign key relationships stay intact?

View solution

Q. Which mode exists at both global level and session-specific level?

View solution

Q. Which system variable determines the number of rows from INSERT DELAYED statements that can be queued per table?

View solution

Q. The largest value to which the variable ‘max_allowed_packet’ can be set is ______________

View solution

Q. Increasing the value of which system variable enables mysqld to keep more tables open simultaneously?

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

View All MCQs on MySQL Database

Suggested Topics

Are you eager to expand your knowledge beyond MySQL Database? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...

DBMS

Get a firm grasp on database systems with our DBMS MCQs. Explore relational...

PHP

Venture into server-side scripting with our PHP MCQs. Cover everything from syntax...

Reverse Engineering

Strengthen your understanding of Reverse Engineering with our curated set of MCQs....

MS Office

Master the suite of productivity tools with our MS Office MCQs. From Word and Excel...

MATLAB

Hone your computational mathematics skills with our MATLAB MCQs. Understand...

IT Fundamentals

Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...

Microprocessor

Understand the heart of your computer with our Microprocessor MCQs. Topics include...

C# programming

Hone your skills in the C# language with our MCQs. Understand data types, operators,...