Oracle OCP题库解析（8）

ITAA-OCM

View the Exhibit.

Which statement regarding the dept and emp tables is true?

A) When you delete a row from the emp table, you would receive a constraint violation error.

B) When you delete a row from the dept table, you would receive a constraint violation error.

C) When you delete a row from the emp table, automatically the corresponding rows are deleted from the dept table.

D) When you delete a row from the dept table, automatically the corresponding rows are deleted from the emp table.

E) When you delete a row from the dept table, automatically the corresponding rows are updated with null values in the emp table.

F) When you delete a row from the emp table, automatically the corresponding rows are updated with null values in the dept table.

Answer: D

ON DELETE CASCADE当主键内容被删除，他所对应的外键内容将自动删除。

523594379

wish_start

学习了

﹎注销ㄨ恛憶

学学一下，加油

q466265670

学习学习

q466265670

学习学习

Ser_rig

wwwww

ray0501

讚喔 恭喜

ray0501

讚喔 恭喜