If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will b – McqOptions

MCQOPTIONS

1.	If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query?SELECT emp_idFROM EmployeeORDER BY emp_id;
A.	{2, 1, 4, 3, 7, 9, 6}
B.	{9, 7, 6, 4, 3, 1, 2}
C.	{1, 2, , 3, 4, 6, 7, 9}
D.	All of above
E.	None of these
Answer» D. All of above

Discussion

No Comment Found

Related MCQs

Is there any error in the following query?SELECT emp_id, title, start_date, fname, fed_idFROM EmployeeORDER BY 3, 4;
Is there any error in the following query?SELECT emp_id, title, start_date, fname, fed_idFROM EmployeeORDER BY LEFT (fed_id, 5);
Is there any error in the following query?SELECT emp_id, title, start_date, First_name, fed_idFROM EmployeeORDER BY RIGHT (fed_id, 3);
If id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query?SELECT idFROM studentORDER BY id ASC;
If id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query?SELECT idFROM StudentORDER BY id DESC;
What is the significance of ORDER BY emp_id ASC in the given query?SELECT id, First_name, Last_nameFROM StudentORDER BY id ASC;
What is the significance of ORDER BY emp_id DESC in the given query?SELECT id, First_name, Last_nameFROM StudentORDER BY id DESC;
What will be the order of sorting in the given query?SELECT emp_id, emp_nameFROM EmployeeORDER BY emp_id, emp_name;
What is the significance of ORDER BY in the given query?SELECT emp_id, fname, lnameFROM EmployeeORDER BY emp_id;
If emp_id contain the following set {-1, -2, 2, 3, -3, 1}, what will be the output on execution of the given query?SELECT idFROM StudentORDER BY id;