100% Guarantee to Pass Your Other Oracle Certification exam and get your Other Oracle Certification Certification.
We guarantee your success in the first attempt. If you do not pass the Other Oracle Certification “1Z0-051″ (Oracle Database: SQL Fundamentals I) on your first attempt, send us the official result. We will give you a FULLY REFUND of your purchasing fee OR send you another same value product for free.
53. View the Exhibit and examine the data in the COSTS table.
You need to generate a report that displays the IDs of all products in the COSTS table whose unit price is at least 25% more than the unit cost. The details should be displayed in the descending order of 25% of the unit cost.
You issue the following query:
SQL>SELECT prod_id
FROM costs
WHERE unit_price >= unit_cost * 1.25
ORDER BY unit_cost * 0.25 DESC;
Which statement is true regarding the above query?
A.It executes and produces the required result.
B.It produces an error because an expression cannot be used in the ORDER BY clause.
C.It produces an error because the DESC option cannot be used with an expression in the ORDER BY clause.
D.It produces an error because the expression in the ORDER BY clause should also be specified in the SELECT clause.
Answer: A
54. Which two statements are true regarding the ORDER BY clause? (Choose two.)
A.It is executed first in the query execution.
B.It must be the last clause in the SELECT statement.
C.It cannot be used in a SELECT statement containing a HAVING clause.
D.You cannot specify a column name followed by an expression in this clause.
E.You can specify a combination of numeric positions and column names in this clause.
Answer: BE
Killtest Practice Exams for 1Z0-051 are written to the highest standards of technical accuracy, provided by our certified subject matter experts and published authors for development.
Related Posts
Thursday, April 23rd, 2009, 1:27 am | 
1Z0-051 | 
RSS feed
Comments and pings are currently closed.
