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 1752

Which two are character manipulation functions? (Choose two.)

Option A

A.    TRUNC
 

Option B

B.    REPLACE
 

Option C

C.    TRIM
 

Option D

D.    MOD
 

Correct Answer B,C
Explanation


Question ID 1753

The STUDENT_GRADES table has these columns:
STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3)
The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest.
Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar?
 

Option A

A.    SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;
 

Option B

B.    SELECT student_id, gpa
FROM student_grades
ORDER BY gpa DESC;


 

Option C

C.    SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;
 

Option D

D.    SELECT student_id, gpa FROM student_grades ORDER BY gpa;
 

Option E

E.    SELECT student_id, gpa FROM student_grades
SORT ORDER BY gpa DESC;
 

Correct Answer B
Explanation

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