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 4908

You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table.
Which set of statements accomplishes this?
 

Option A

A.    CREATE ROLE registrar; GRANT MODIFY ON student_grades TO registrar; GRANT registrar to user1, user2, user3
 

Option B

B.    CREATE NEW ROLE registrar; GRANT ALL ON student_grades TO registrar; GRANT registrar to user1, user2, user3
 

Option C

C.    CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT ROLE registrar to user1, user2, user3
 

Option D

D.    CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT registrar to user1, user2, user3;
 

Option E

E.    CREATE registrar; GRANT CHANGE ON student_grades TO registrar; GRANT registrar;
 

Correct Answer D
Explanation


Question ID 4909

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 ORDER BY gpa ASC;
 

Option B

B.    SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;
 

Option C

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

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;
 

Option F

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

Correct Answer F
Explanation

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