Oracle
1Z0-071 · Question #368
1Z0-071 Question #368: Real Exam Question with Answer & Explanation
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
Community Discussion
No community discussion yet for this question.