READ Free Dumps For Oracle- 1z1-051
| Question ID 4926 | What is true about updates through a view? |
| Option A | A. You cannot update a view with group functions. |
| Option B | B. When you update a view group functions are automatically computed. |
| Option C | C. When you update a view only the constraints on the underlying table will be in effect. |
| Option D | D. When you update a view the constraints on the views always override the constraints on the underlying tables. |
| Correct Answer | A |
| Question ID 4927 | You need to write a SQL statement that returns employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less |
| Option A | A. SELECT a.emp_name, a.sal, b.dept_id, MAX(sal) FROM employees a, departments b WHERE a.dept_id = b.dept_id AND a.sal < MAX(sal) GROUP BY b.dept_id; |
| Option B | B. SELECT a.emp_name, a.sal, a.dept_id, b.maxsal FROM employees a, (SELECT dept_id, MAX(sal) maxsal FROM employees GROUP BY dept_id) b WHERE a.dept_id = b.dept_id AND a.sal < b.maxsal; |
| Option C | C. SELECT a.emp_name, a.sal, a.dept_id, b.maxsal FROM employees a WHERE a.sal < (SELECT MAX(sal) maxsal FROM employees b GROUP BY dept_id); |
| Option D | D. SELECT emp_name, sal, dept_id, maxsal FROM employees, (SELECT dept_id, MAX(sal) maxsal FROM employees GROUP BY dept_id) WHERE a.sal < maxsal; |
| Correct Answer | B |