READ Free Dumps For Oracle- 1z0-001
| Question ID 8120 | The employee table contains these columns: ID NUMBER(9) LAST_NAME VARCHAR2(25) FIRST_NAME VARCHAR2(25) COMMISSION NUMBER(7,2) You need to display the current commission for all employees. Desired results are: 1. Display the commission multiplied by 1.5 2. Exclude employees with zero commission. 3. Display a zero for employees with null commission value. Evaluate this SQL statement. SELECT id, last_name, first_name, commission*1. 5 FROM employee WHERE commission <>0; Which of the desired results does the statement provide? |
| Option A | All the desired results. |
| Option B | Two of the desired results. |
| Option C | One of the desired results. |
| Option D | A syntax error. |
| Correct Answer | B |
| Question ID 8121 | View the EXHIBIT. Examine the trace instance chart for employee table. You want to display each employee hire date from earliest to latest. Which SQL statement will you use? |
| Option A | SELECT hire_date FROM employee; |
| Option B | SELECT hire_date FROM employee ORDER BY hire_date; |
| Option C | SELECT employee FROM employee ORDER by hire_date; |
| Option D | SELECT hire_date FROM employee ORDER BY hire_date DESC; |
| Correct Answer | B |