READ Free Dumps For Oracle- 1z0-001
| Question ID 8063 | The employee table contains these columns: Last_name Varchar2 (25) First_name Varchar2 (25) Salary Number7, 2 You need to display the names of employees on more than an average salary of all employees. Evaluate the SQL statement. SELECT LAST_NAME, FIRST_NAME from employee where salary< avg(salary); Which change should you make to achieve the desired results? |
| Option A | Change the function in the Where clause. |
| Option B | Move the function to the select clause and add a group clause. |
| Option C | Use a sub query in the where clause to compare the average salary value. |
| Option D | Move the function to the select clause and add a group by clause and a having clause. |
| Correct Answer | C |
| Question ID 8064 | The employee table contains these columns: FIRST-NAME VARCHER2(25) COMISSION NUMBER(3,2) Evaluate this SQL statement SELECT first-name,commission FROM employee WHERE commission= (SELECTcomission FROM employee WHERE UPPER(first-name)= 'scott') Which statement will cause this statement to fail? |
| Option A | Scott has a null commission resolution. |
| Option B | Scott has a zero commission resolution. |
| Option C | There is no employee with the first name Scott. |
| Option D | The first name values in the data base are in the lower case. |
| Correct Answer | A |