What will be the order of sorting in the given query?SELECT emp_id, em – McqOptions

MCQOPTIONS

1.	What will be the order of sorting in the given query?SELECT emp_id, emp_nameFROM EmployeeORDER BY emp_id, emp_name;
A.	Sorting {emp_name, emp_id}
B.	Sorting (emp_id} but not emp_name
C.	Sorting {emp_id, emp_name}
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;