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;

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

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_id FROM Employee ORDER 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? <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>

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;

Discussion

No Comment Found

Related MCQs

Reply to Comment

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_id
FROM Employee
ORDER BY emp_id;