Which statement is true about triggers on data definition language (DDL) statements?

bala

A and B is correct

Reply

bala

for answer check this link
http://www.vsevolod.com/magz/ORplSQLl/0596005873/oracleplsqldba-chp-1-sect-13.html

Reply

sergey

A is not correct you can create ddl triggers on ANY Oracle object not just tables and indexes.
B the answer is ambigous “Defined by” if that means that you can have either schema system triggers or database system triggers then it is correct. THe answer makes it sound like a question about privileges needed to create a trigger rather than DDL triggers.
C is also correct if you make a schema trigger on schema HR say on the event ALTER then it will fire for any ALTER statements made by HR but not for any other users.
D is correct all can be tracked with different events available in system triggers.
So I think there is a problem with the question here, perhaps it should have multiple answers definitely D, you could argue B and C as well

Reply

qaisarimtiaz

i think D is correct.

Reply

Sid

D

Reply

Arturo

B is correct

Reply

Marian

C is the most likely. DDL triggers are defined for schemas and not for tables, views …

Reply

Samuel ardila

I think is B.
maybe B and C are correct, BUT,

answer B :
CREATE TRIGGER BEFORE CREATE ON DATABASE (for all schemas).
CREATE TRIGGER BEFORE CREATE ON USER.SCHEMA(for USER schema).

answer C :
User B has a DDL trigger on his own table (table_1)
User B creates a procedure proc_1 with definer rights.
Proc_1 has a DDL statement that affects table_1
User A call a procedure proc_1,
So.. When user A call proc_1, the trigger is fire.
C is maybe not correct.

Reply

Vladimir_K

Answer is B. C is wrong because: http://sqlandplsql.com/2013/12/28/ddl-triggers-oracle/

Reply

Vladimir K

D

Reply

Vladimir K

‘create’ can be on tablespase – http://www.techonthenet.com/oracle/tablespaces/create_tablespace.php

Reply

salvo

D

Reply

Uladzimir

The answer is D ONLY.

A is wrong. DDL triggers can be applied to the statistics, table space, view, grants etc.
http://psoug.org/reference/ddl_trigger.html

B is wrong. NOT any user can create/change triggers.
To create trigger you need special priviligies:
http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7004.htm

C is wrong. They can be fired by anoter user, not only current user

D is corect:
http://www.dba-oracle.com/t_ddl_triggers.htm

DDL triggers — Using Oracle DDL triggers, the Oracle administrator can automatically track all changes to the database including changes to tables, indexes, and constraints. The data from this trigger is especially useful for change control for the Oracle DBA.

Reply

roman

B is correct

D is wrong
DDL triggers fire only if the object being created is a cluster, function, index, package, procedure, role, sequence, synonym, table, tablespace, trigger, type, view, or user.

C is wrong
Not only the owner.

Reply

Fabio

Answer is D. It’s just true.

Reply

Leo Yu

a) incorrect, DDL trigger can be on table space, table, view, synonym, package, cluster etc, cannot be database
link, dimension. Basically can be on schema objects but cannot be on remote objects
b) incorrect, if the user has “adminster system trigger”, he can create trigger on database;
if the user has “create any trigger”, he can create trigger on other schema; if the user has “create trigger”,
he can create trigger on his own schema. Obviously “defined by all user” is incorrect: not all user has all the priviledge
requsted
c) incorrect, like “after ddl on database”
d) correct

Reply

Rakesh

I Chose D and got incorrect answer during exam.

Reply

fadi

how did you know its the incorrect answer during the exam ?

Reply

Mohammed Oraif

D is the correct answer.

Reply

Elaya Perumal

Hi All,

I am planning to write a exam 1Z0-144. If any one have updated dumps .Please share with me
[email protected]

Thanks
Elaya

Reply

Mishtgu

Доброго времени суток друзья!

Производство грузозахватных приспособлений.

Я недавно устроился туда и хочется услышать отзыв о компании. Желательно положительный.

Вам предоставляется консультация специалиста и делается предварительный расчет стоимости.

Нам будет приятно видеть у нас на сайте

Увидимся!

Reply