Evaluate the following SQL statement: ALTER TABLE hr.emp SET UNUSED (mgr_id); Which statement is true regarding the effect of the above SQL statement?

Question

Options

• AAny synonym existing on the EMP table would have to be re-created.
• BAny constraints defined on the MGR_ID column would be removed by the above command.
• CAny views created on the EMP table that include the MGR_ID column would have to be dropped and re-
• DAny index created on the MGR_ID column would continue to exist until the DROP UNUSED COLUMNS

• A
  6% (3)
• B
  80% (43)
• C
  2% (1)
• D
  13% (7)

No community discussion yet for this question.