READ Free Dumps For Oracle- 1z0-007
Question ID 7995 | Examine this statement: SELECT student_id, gpa FROM student_grades WHERE gpa >&&value; You run the statement once, and when prompted you enter a value of 2.0. A report is produced. What happens when you run the statement a second time? |
Option A | An error is returned |
Option B | You are prompted to enter a new value. |
Option C | A report is produced that matches the first report produced. |
Option D | You are asked whether you want a new value or if you want to run the report based on the previous value. |
Correct Answer | C |
Question ID 7996 | Which SQL statement returns a numeric value? |
Option A | SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP; |
Option B | SELECT ROUND(hire_date) FROM EMP; |
Option C | SELECT sysdate-hire_date FROM EMP; |
Option D | SELECT TO_NUMBER(hire_date + 7) FROM EMP; |
Correct Answer | C |