Oracle
1Z0-071 · Question #368
You execute this command: ALTER TABLE employees SET UNUSED (department_id) Which two are true? (Choose two.)
The correct answer is 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. See the full explanation below for the reasoning.
Question
You execute this command:
ALTER TABLE employees SET UNUSED (department_id) Which two are true? (Choose two.)
Options
- ANo updates can be made to the data in the DEPARTMENT_ID column.
- BA new column with the name DEPARTMENT_ID can be added to the EMPLOYEES table.
- CA query can be display data from the DEPARTMENT_ID column.
- DThe DEPARTMENT_ID column is set to null for all rows in the table.
- EThe DEPARTMENT_ID column can be recovered from the recycle bin.
- FThe storage space occupied by the DEPARTMENT_ID column is released only after a COMMIT
How the community answered
(42 responses)- A79% (33)
- C12% (5)
- D2% (1)
- E2% (1)
- F5% (2)
Community Discussion
No community discussion yet for this question.