AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z1-051





Question ID 4856

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?

 

Option A

A.    It executes and produces the required result.
 

Option B

B.    It produces an error because an expression cannot be used in the ORDER BY clause.
 

Option C

C.    It produces an error because the DESC option cannot be used with an expression in the ORDER BY clause.
 

Option D

D.    It produces an error because the expression in the ORDER BY clause should also be specified in the SELECT clause.
 

Correct Answer A
Explanation


Question ID 4857

Which two statements are true regarding sub queries? (Choose two.)
 

Option A

A.    A sub query can retrieve zero or more rows.
 

Option B

B.    Only two sub queries can be placed at one level.
 

Option C

C.    A sub query can be used only in SQL query statements.
 

Option D

D.    A sub query can appeal* on either side of a comparison operator.
 

Option E

E.    There is no limit on the number of sub query levels in the WHERE clause of a SELECT statement.
 

Correct Answer A,D
Explanation

Send email to admin@getfreedumps for new dumps request!!!