What is the significance of ORDER BY emp_id ASC in the given query?S – McqOptions

MCQOPTIONS

1.	What is the significance of ORDER BY emp_id ASC in the given query?SELECT id, First_name, Last_nameFROM StudentORDER BY id ASC;
A.	Data of id will be sorted in either ascending or descending order
B.	Data of id will be sorted in descending order
C.	Data of id will be sorted in ascending order
D.	All of above
E.	None of these
Answer» C. Data of id will be sorted in ascending order

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;