Page 1 of 1
Re: About Question enthuware.ocpjp.v17.2.3750 :
Posted: Mon Dec 12, 2022 8:10 am
by kabanvau
If your query doesn’t have an ORDER BY clause, you can’t reliably predict the order of your ResultSet. So it should be:
Code: Select all
select * from department ORDER BY id
Re: About Question enthuware.ocpjp.v17.2.3750 :
Posted: Mon Dec 12, 2022 9:04 am
by admin
It is true that order cannot be guaranteed without the order by clause in the query. However, you might see such a question in the exam where there is no "order by" clause but the output assumes a particular order when the options do not depend on the order. In this question also, all the options assume that the first row in the result will be the row with id 1 and so you can answer based on that.