15. 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?
A. Any synonym existing on the EMP table would have to be recreated.
B. Any constraints defined on the MGR_ID column would be removed by the above command.
C. Any views created on the EMP table that include the MGR_ID column would have to be dropped and
recreated.
D. Any index created on the MGR_ID column would continue to exist until the DROP UNUSED
COLUMNS command is executed.
Answer: B
B没有问题。但我试验发现视图也同样不能用了,需要重建,C不对的原因是什么?
希望各位前辈帮忙。我不希望背题目,希望能够知其所以。
谢谢!
ALTER TABLE hr.emp
SET UNUSED (mgr_id);
Which statement is true regarding the effect of the above SQL statement?
A. Any synonym existing on the EMP table would have to be recreated.
B. Any constraints defined on the MGR_ID column would be removed by the above command.
C. Any views created on the EMP table that include the MGR_ID column would have to be dropped and
recreated.
D. Any index created on the MGR_ID column would continue to exist until the DROP UNUSED
COLUMNS command is executed.
Answer: B
B没有问题。但我试验发现视图也同样不能用了,需要重建,C不对的原因是什么?
希望各位前辈帮忙。我不希望背题目,希望能够知其所以。
谢谢!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/88933/viewspace-675657/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/88933/viewspace-675657/