If in Table Customer , a column Customer_id consists of {1,2,2,3,3, – McqOptions

MCQOPTIONS

1.	If in Table Customer , a column Customer_id consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following query?SELECT DISTINICT emp_idFROM employee;
A.	{1,2,3,5,6,7,8}
B.	{ }
C.	{1,2,2,3,3,5,6,7,8,8}
D.	All of above
E.	None of these
Answer» B. { }

Discussion

No Comment Found

Related MCQs

In the following query * stands for SELECT * FROM Employee;
In the following query Employee stands forSELECT Emp_id, fname, lname, Birth_date FROM Employee;
What will be the output of a query given below?SELECT *FROM Employee;
Find the error?SELECT *;
What will be the output of a query given below?SELECT Employee_id, FirstName, LastNameFROM person;
Is there any error in executing the following query?SELECT USER (),VERSION (), DATABASE ();
Is there any error in executing the following query?SELECT Student_id, ACTIVE ,Student_id * 3.145,UPPER (LastName)FROM Student;
If in Table Customer , a column Customer_id consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following query?SELECT DISTINICT emp_idFROM employee;
If in Table account , a column Customer_id consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following query?SELECT DISTINICT Customer_idFROM account;
What will be the result of the query given below?SELECT Person_id, ACTIVE AS STATUS,Person_id * 3.14 AS Person_pi,UPPER (LName) AS Last_NameFROM Person;