READ Free Dumps For Oracle- 1z0-020
Question ID 7778 | Examine this statement: SELECT deptno, job, SUM(sal) FROM emp Which GROUP BY clause would you use to generate a subtotal of the sum of salaries in each department, and a subtotal of the sum of salaries of all the different job types? |
Option A | GROUP BY deptno, job; |
Option B | GROUP BY CUBE (deptno, job); |
Option C | GROUP BY ROLLUP (deptno, job); |
Option D | GROUP BY SUM (deptno), SUM (job); |
Option E | GROUP BY CUBE (deptno, job, sal); |
Correct Answer | C |
Question ID 7779 | Why would you drop a column instead of marking it unused? |
Option A | You want to release the space. |
Option B | You want it to process more quickly. |
Option C | You want users to be able to modify the table during the operation. |
Option D | You want to prevent users from creating a new column with the same name. |
Option E | You want the column data to be available again on export or import of the table. |
Correct Answer | A |