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