请选择 进入手机版 | 继续访问电脑版

北京oracle培训_oracle培训哪家好_CUUG官方论坛_CUUG培训怎么样_CUUG官网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索
查看: 356|回复: 0

Oracle OCP 19c 认证1Z0-082考试题库(第19题)CUUG整理

[复制链接]

360

主题

401

好友

2万

积分

管理员

Rank: 9Rank: 9Rank: 9

发表于 2021-6-2 11:38:26 |显示全部楼层
Oracle OCP 19c 认证1Z0-082考试题库(第19题)-CUUG内部学员版082题库解析
19、choose the best answer 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 views created on the EMP table that include the MGR_ID column would be automatically modified and remain valid.
B) Any constraints defined on the MGR_ID column would be removed by the above command.
C) Any synonym existing on the EMP table would have to be re-created.
D) Any index created on the MGR in column would continue to exist until the DROP UNUSED COLUMNS command is executed.

回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

QQ|手机版|CUUG认证培训 ( 京ICP备11008061号 )  

GMT+8, 2021-11-29 04:31 , Processed in 0.022847 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部