The keyword used with UNION that retains duplicate rows is ___________ – McqOptions

MCQOPTIONS

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

Discussion

No Comment Found

Related MCQs

Identify the table name in the following statement.<br><pre class="prettyprint lang-c">INSERT INTO Employee VALUES('Ajit','M',NULL);<br></pre>
x in the following statement is ____________.<br><pre class="prettyprint lang-c">DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;<br></pre>
In the following code, InnoDB is __________.<br><pre class="prettyprint lang-c">CREATE TABLE Employee(<br> Emp_name CHAR(30),<br> Emp_id INT(10),<br> PRIMARY KEY (Emp_id)<br> ) ENGINE = InnoDB;<br></pre>
What column names are displayed when this command is executed?<br><pre class="prettyprint lang-c">SHOW COLUMNS FROM Table_Name LIKE '%name';<br></pre>
abc in the following statement is ___________.<br><pre class="prettyprint lang-c">DELETE FROM xyz WHERE abc = 5;<br></pre>
The collations this statement lists are ______________.<br><pre class="prettyprint lang-c">SHOW COLLATION LIKE 'utf8%'<br></pre>
What is tamp in the following command?<br><pre class="prettyprint lang-c">mysql -h xyz.host.try.net -p -u tamp<br></pre>
What is the host name in the following command?<br><pre class="prettyprint lang-c">mysql -h interview.mania.com -p -u sampadam<br></pre>
The number of attributes in the following table is ______________.<br><pre class="prettyprint lang-c">CREATE TABLE Student(<br> name CHAR(30),<br> id INT(11)<br> );<br></pre>
What does Student & name specify?<br><pre class="prettyprint lang-c">CREATE TABLE Student (name);<br></pre>