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

Lorean

2 months ago

I'm so triggered by this question, I might just throw my computer out the window. But seriously, the answer is A) ROW.

upvoted 0 times

...

Curtis

2 months ago

This is a tricky one, but I'm pretty sure the correct answer is A) ROW. Who else is hungry for a trigger-filled meal right now?

upvoted 0 times

Wilburn

12 days ago

I agree, let's dig into some trigger-filled meal together!

upvoted 0 times

...

Melynda

28 days ago

I'm always hungry for some trigger knowledge!

upvoted 0 times

...

Angella

1 months ago

I think you're right, the answer is A) ROW.

upvoted 0 times

...

Annamaria

2 months ago

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

upvoted 0 times

Hayley

1 months ago

That's correct, the answer is D) BEFORE STATEMENT.

upvoted 0 times

...

Myra

1 months ago

I think you're right, it should be D) BEFORE STATEMENT.

upvoted 0 times

...

Selma

2 months ago

Yes, you are correct! :OLD and :NEW identifiers can be used in BEFORE triggers.

upvoted 0 times

...

Dianne

2 months ago

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

upvoted 0 times

Temeka

9 days ago

D) BEFORE STATEMENT

upvoted 0 times

...

Marla

12 days ago

Yes, you are correct! :OLD and :NEW identifiers can be used in AFTER STATEMENT triggers.

upvoted 0 times

...

Lashanda

19 days ago

C) AFTER STATEMENT

upvoted 0 times

...

Cherelle

2 months ago

B) AFTER SUSPEND

upvoted 0 times

...

Kris

2 months ago

A) ROW

upvoted 0 times

...

Curt

2 months ago

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

upvoted 0 times

...

Nida

2 months ago

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

upvoted 0 times

...

Tamesha

2 months ago

I think the answer is A) ROW trigger.

upvoted 0 times

...

Galen

2 months ago

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

upvoted 0 times

Domonique

1 months ago

Yes, you're right. :OLD and :NEW identifiers can only be used in ROW triggers.

upvoted 0 times

...

Brigette

1 months ago

I think the answer is A) ROW.

upvoted 0 times

...

Nicholle

2 months ago

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

upvoted 0 times

...

Kathryn

2 months ago

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

upvoted 0 times

...

Leonora

3 months ago

I think the answer is A) ROW trigger.

upvoted 0 times

...