What will be the order of sorting in the given query?

1.	What will be the order of sorting in the given query?
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? <pre class="prettyprint lang-c">SELECT emp_id, title, start_date, fname, fed_id FROM Employee ORDER BY 3, 4; </pre>
Is there any error in the following query? <pre class="prettyprint lang-c">SELECT emp_id, title, start_date, fname, fed_id FROM Employee ORDER BY LEFT (fed_id, 5); </pre>
Is there any error in the following query? <pre class="prettyprint lang-c">SELECT emp_id, title, start_date, First_name, fed_id FROM Employee ORDER BY RIGHT (fed_id, 3); </pre>
If id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query? <pre class="prettyprint lang-c">SELECT id FROM student ORDER BY id ASC; </pre>
If id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query? <pre class="prettyprint lang-c">SELECT id FROM Student ORDER BY id DESC; </pre>
What is the significance of ORDER BY emp_id ASC in the given query? <pre class="prettyprint lang-c">SELECT id, First_name, Last_name FROM Student ORDER BY id ASC; </pre>
What is the significance of ORDER BY emp_id DESC in the given query? <pre class="prettyprint lang-c">SELECT id, First_name, Last_name FROM Student ORDER BY id DESC; </pre>
What will be the order of sorting in the given query? <pre class="prettyprint lang-c">SELECT emp_id, emp_name FROM Employee ORDER BY emp_id, emp_name; </pre>
What is the significance of ORDER BY in the given query? <pre class="prettyprint lang-c">SELECT emp_id, fname, lname FROM Employee ORDER BY emp_id; </pre>
If emp_id contain the following set {-1, -2, 2, 3, -3, 1}, what will be the output on execution of the given query? <pre class="prettyprint lang-c">SELECT id FROM Student ORDER BY id; </pre>

What will be the order of sorting in the given query?

Discussion

No Comment Found

Related MCQs

Reply to Comment