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 7979

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?

Option A

ALTER TABLE students ADD PRIMARY KEY _ id;

Option B

ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);

Option C

ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;

Option D

ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

Option E

ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

Correct Answer D
Explanation Explanation/Reference: Explanation : ALTER TABLE table_name ADD [CONSTRAINT constraint] type (coloumn); Incorrect answer : A wrong syntax B wrong syntax C wrong syntax E no such MODIFY keyword Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 10-17


Question ID 7980

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

SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;

Option B

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

Option C

SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;

Option D

SELECT student_id, gpa FROM student_grades ORDER BY gpa;

Option E

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

Option F

SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;

Correct Answer F
Explanation Explanation/Reference: Explanation : sorted by highest to lowest is DESCENDING order Incorrect answer : A result in ascending order B wrong syntax with SORT keyword C wrong syntax with SORT keyword D default value for ORDER by is in ascending order E wrong syntax with SORT keyword Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 2-22

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