Oracle Exam 1Z0-149 Topic 13 Question 26 Discussion

Actual exam question for Oracle's 1Z0-149 exam

Question #: 26
Topic #: 13

[All 1Z0-149 Questions]

In which type of trigger can :OLD and :NEW identifiers be used?

AROW

BAFTER SUSPEND

CAFTER STATEMENT

DBEFORE STATEMENT

Show Suggested Answer

Suggested Answer: A, D

https://docs.oracle.com/database/122/LNPLS/ACCESSIBLE-BY-clause.htm

by Gertude at May 12, 2024, 07:38 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-149 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Annamaria

2 days ago

Hold on, isn't :OLD and :NEW used in BEFORE triggers? So the answer should be D) BEFORE STATEMENT.

upvoted 0 times

...

Dianne

8 days ago

I think it's C) AFTER STATEMENT, because that's when we can access the changed data, right?

upvoted 0 times

...

Curt

12 days ago

I'm not sure, but I think it's D) BEFORE STATEMENT trigger.

upvoted 0 times

...

Nida

13 days ago

I agree with Tamesha, because :OLD and :NEW identifiers are used in row triggers.

upvoted 0 times

...

Tamesha

14 days ago

I think the answer is A) ROW trigger.

upvoted 0 times

...

Galen

17 days ago

The :OLD and :NEW identifiers can only be used in ROW triggers, so the answer is A) ROW.

upvoted 0 times

...

Nicholle

17 days ago

I'm not sure, but I think it's D) BEFORE STATEMENT trigger.

upvoted 0 times

...

Kathryn

20 days ago

I agree with Leonora, because in ROW triggers, we can access both :OLD and :NEW values.

upvoted 0 times

...

Leonora

29 days ago

I think the answer is A) ROW trigger.

upvoted 0 times

...