READ Free Dumps For Oracle- 1z0-001
| Question ID 8164 | Given the cursor statement: DECLARE CURSOR query_cursor(v_salary)IS SELECT last_name,salary,dept_no FROM employee WHERE SALARY>v_salary; Why does this statement cause an error? |
| Option A | The parameter mode is not defined. |
| Option B | A where clause is not allowed in a cursor statement. |
| Option C | The into clause is missing from the select statement. |
| Option D | A scalar data type was not specified for the parameter. |
| Correct Answer | D |
| Question ID 8165 | Examine the structure: EMP TABLE NAME NULL? TYPE EMP NUMBER NOT NULL NUMBER(4) VARCHER2 NUMBER(10) JOB VARCHAR2 NUMBER(2,9) MGR NUMBER(4) HARIDATE DATE SALARY NUMBER(7,2) COMM NUMBER(7,2) DEPT NO NOT NULL NUMBER(2) TAX TABLE NAME NULL? TYPE TAX GRADE NUMBER LOWSAL NUMBER HIGHSAL NUMBER You want to create a report that displays the employee details along with the tax category of each employee. The tax category is determined by comparing the salary of the employee from the emp table to the lower and the upper salary values in the tax table. Which select statement produces the required result? |
| Option A | SELECT e.name,e.salary,t.tax grade FROM emp e,tax t WHERE e.salary between t.lowsal and t.highsal; |
| Option B | SELECT e.name,e.salary,t.tax grade FROM emp e,tax t WHERE e.salary>=t.lowsal and <= t.highsal; |
| Option C | SELECT e.name,e.salary,t.tax grade FROM emp e,tax t WHERE e.salary=t.highsal; |
| Option D | SELECT e.name,e.salary,t.tax grade FROM emp e,tax t WHERE e.salary in t.lowsal and t.highsal; |
| Correct Answer | A |