QUESTION 4 -- 10g OCP 升级11g OCP 1Z0-053

最新推荐文章于 2018-10-10 20:20:12 发布

原创最新推荐文章于 2018-10-10 20:20:12 发布 · 525 阅读

0 ·

CC 4.0 BY-SA版权

通过11g OCP 题库学习新特性专栏收录该内容

4 篇文章

订阅专栏

阐述了在数据库表重构后，与表关联的触发器的状态变化，包括它们是否仍然有效以及如何重新验证。

Which statement describes the effect of table redefinition on the triggers attached to the table?
A. All triggers on the table remain valid.
B. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on
the table.
C. All triggers on the table are invalidated and must be manually recompiled before the next DML execution
on the table.
D. Only triggers that are affected by the changes to the structure of the table are invalidated and
automatically revalidated with the next DML execution on the table.

Answer: B

comment:

Dependent views, triggers, functions, procedures, and packages are invalidated. Oracle Database attempts to revalidate them when they are next accessed, but you may need to alter these objects with the new column name if revalidation fails.

reference link:

http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_3001.htm#SQLRF01001