【单选题】View the exhibit and examine the TRANS table's storage information. After a massive delete operation, you executed the following statement to shrink the TRANS table: SQL> ALTER TABLE trans SHRINK SPAC...
A.
An error is produced.
B.
The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted
C.
The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged
D.
The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process
【单选题】Examine the structure of the EMP_DEPT_VU view: Column Name Type Remarks EMPLOYEE_ID NUMBER From the EMPLOYEES table EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEE...
A.
SELECT * FROM emp_dept_vu;
B.
SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;
C.
SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;
D.
SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) > 20000
E.
None of the statements produce an error; all are valid.