The keyword used with UNION that does not retain duplicate rows is ___ – McqOptions

MCQOPTIONS

1.	The keyword used with UNION that does not retain duplicate rows is _____________.
A.	DISTINCT
B.	STRICT
C.	NARROW
D.	ALL
E.	None of these
Answer» B. STRICT

Discussion

No Comment Found

Related MCQs

The following statement is valid.<br><pre class="prettyprint lang-c">SELECT name, id FROM person UNION name, salary FROM Employee;<br></pre>
The statement used to obtain access privileges to an account is ______________.
The stored-routine privileges are contained in ______________.
The grant table that stores users who can connect to the server and their global privileges is ______________.
The keyword used with UNION that retains duplicate rows is ______________.
The keyword used with UNION that does not retain duplicate rows is _____________.
The following statement is valid.
The operators used when a subquery returns multiple rows to be evaluated in comparison to the outer query are _____________.
The ALL subquery performs the operation _____________.