READ Free Dumps For Oracle- 1z0-007
Question ID 1724 | Which three statements about subqueries are true? (Choose three.) |
Option A | A. A single row subquery can retrieve only one row but many columns. |
Option B | B. A multiple row subquery can be compared using the ">" operator. |
Option C | C. A single row subquery can use the IN operator. |
Option D | D. A multiple row subquery can use the "=" operator. |
Option E | E. A multiple row subquery can retrieve multiple rows and multiple columns. |
Option F | F. A single row subquery can retrieve only one column and one row. |
Correct Answer | A,C,E |
Question ID 1725 | The STUDENT_GRADES table has these columns: |
Option A | A. SELECT MAX(gpa) |
Option B | B. SELECT (gpa) |
Option C | C. SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL; |
Option D | D. SELECT MAX(gpa) STUDENT_ID NUMBER(12) |
Correct Answer | A |