READ Free Dumps For Oracle- 1z0-007
| Question ID 8047 | The STUDENT_GRADES table has these columns STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds students who have a grade point average (GPA) greater than 3.0 for the calendar year 2001? |
| Option A | SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' OR gpa > 3.; |
| Option B | SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' AND gpa gt 3.0; |
| Option C | SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' AND gpa > 3.0; |
| Option D | SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' AND gpa > 3.0; |
| Option E | SELECT student_id, gpa FROM student_grades WHERE semester_end > '01-JAN-2001' OR semester_end < '31-DEC-2001' AND gpa >=s 3.0; |
| Correct Answer | C |
| Question ID 8048 | Exhibit ORDERS ORD_ID ORD_DATE CUST_ID ORD_TOTAL 12-JAB- 100 15 10000 09-MAR- 101 40 8000 09-MAR- 102 35 12500 15-MAR- 103 15 12500 25-JUN- 104 15 6000 18-JUL- 105 20 5000 18-JUL-106 35 7000 04-AUG- 108 10 8000 CUSTOMERS CUST_ID CUST_NAME CITY 10 Smith Los Angeles 15 Bob San Francisco 20 Martin Chicago 25 Mary New York 30 Rina Chicago 35 Smith New York 40 Linda New York Evaluate this SQL statement: SELECT cust_id, ord_total FROM orders WHERE ord_total > ANY (SELECT ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE city LIKE 'New York')); What is the result when the above query is executed? |
| Option A | CUST_ID ORD_TOTAL 15 10000 40 8000 35 12500 15 12500 10 8000 |
| Option B | CUST_ID ORD_TOTAL 15 10000 35 12500 15 12000 |
| Option C | CUST_ID ORD_TOTAL 15 10000 40 8000 15 12000 15 6000 20 5000 35 7000 20 6500 10 8000 |
| Option D | CUST_ID ORD_TOTAL 15 6000 20 5000 20 6500 |
| Option E | The query returns no rows. |
| Option F | The query fails because ANY is not a valid operator with a subquery. |
| Correct Answer | A |