关于trigger触发的问题

田野

我用的是oracle 8.1.5

ccniu

我又仔细研究了一下文档，觉得database event这个说法有些含糊。文档中说
database events 包括:
   system events :
        -database startup and shutdown
        -server error message events
   user events :
        -user logon and logoff
        -DDL statements (CREATE, ALTER, and DROP)
        -DML statements (INSERT, DELETE, and UPDATE)

似乎与考题中的database event有些不同。
文档中又说：
Triggers on system events can be defined at the database level or schema level.Triggers on DDL statements or logon/logoff events can also be defined at the database level or schema level. Triggers on DML statements can be defined on a table or view. A trigger defined at the database level fires for all users, and a trigger defined at the schema or table level fires only when the triggering event involves that schema or table.

我觉得文中的A trigger defined at the database level or schema level与考题中的database event trigger才是同义。呵呵，当时我也碰到了这一题，我就是把database event trigger理解为A trigger defined at the database level or schema level 来答题的(A,C,E)。我可从来没考虑过是否on schema。

ccniu

最初由 田野 发布
[B]我用的是oracle 8.1.5 [/B]

after ddl on schema 要在8.1.6以后才能使用

ZALBB

但题目问的是 database event ，所以我觉得是ACE

markriver

对