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- 1z0-007





Question ID 1730

Evaluate these two SQL statements:
SELECT last_name, salary , hire_date FROM EMPLOYEES
ORDER BY salary DESC;
SELECT last_name, salary , hire_date
FROM EMPLOYEES ORDER BY 2 DESC;
What is true about them?
 

Option A

A.    The second statement returns a syntax error.
 

Option B

B.    The two statements produce identical results.
 

Option C

C.    The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

 

Option D

D.    There is no need to specify DESC because the results are sorted in descending order by default.

Correct Answer B
Explanation


Question ID 1731

Which four statements correctly describe functions that are available in SQL? (Choose four.)

Option A

A.    TRUNCATE rounds the column, expression, or value to n decimal places.
 

Option B

B.    TRIM trims the heading or trailing characters (or both) from a character string.
 

Option C

C.    DECODE translates an expression after comparing it to each search value.

 

Option D

D.    INSTR returns the numeric position of a named character.
 

Option E

E.    NVL compares two expressions and returns null if they are equal, or the first expression if they are not equal.
 

Option F

F.    NULLIF compares two expressions and returns null if they are equal, or the first expression if they are not equal.

Correct Answer B,C,D,F
Explanation

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