Free Oracle 1Z0-007 Exam Dumps Questions & Answers

The STUDENT_GRADES table has these columns:
STUDENT_ID NUMBER (12)
SEMESTER_END DATE
GPA NUMBER (4,3)
The register has requested a report listing the students' grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?

• A.  SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semester_end ASC;
• B.  SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semester_end DESC;
• C.  SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;
• D.  SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end, gpa DESC;
• E.  SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end ASC, gpa ASC;

You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table.
Some of the employees may not have a phone number available.
Which data manipulation operation do you perform?

• A.  ENTER
• B.  UPDATE
• C.  You cannot enter the phone numbers for the existing employee records.
• D.  INSERT
• E.  ADD
• F.  MERGE

Examine the data from the ORDERS and CUSTOMERS tables.

Evaluate the SQL statement:
SELECT * FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Smith');
What is the result when the query is executed?

• A.  Option B
• B.  Option E
• C.  Option D
• D.  Option A
• E.  Option C

Examine the statement:
GRANT select, insert, update
ON student_grades
TO manager
WITH GRANT OPTION;
Which two are true? (Choose two.)

• A.  It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.
• B.  It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
• C.  It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.
• D.  It allows the MANAGER to pass the specified privileges on to other users.
• E.  It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.
• F.  MANAGER must be a role.

Which is an iSQL*Plus command?

• A.  SELECT
• B.  DESCRIBE
• C.  UPDATE
• D.  INSERT
• E.  DELETE
• F.  RENAME