Oracle
1Z0-071 · Question #368
You execute this command: ALTER TABLE employees SET UNUSED (department_id) Which two are true? (Choose two.)
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #368. The question stem and answer options stay visible for context.
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
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.