You execute this command:
ALTER TABLE employees SET UNUSED(department_id)
Which two are true? (Choose two.)
A. No updates can be made to the data in the DEPARTMENT_ID column.
B. A new column with the name DEPARTMENT_ID can be added to the EMPLOYEES table.
C. A query can be display data from the DEPARTMENT_ID column.
D. The DEPARTMENT_ID column is set to null for all rows in the table.
E. The DEPARTMENT_ID column can be recovered from the recycle bin.
F. The storage space occupied by the DEPARTMENT_ID column is released only after a COMMIT is issued.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
A, B
A and B are the correct answer, when the column is marked UNUSED then we cannot see the data of it and it will allow us to add a new column with same name in table
AB Is correct
AB
AB is correct