Oracle Exam 1Z0-149 Topic 14 Question 49 Discussion

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

Question #: 49
Topic #: 14

[All 1Z0-149 Questions]

Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)

APACKAGES

BVARIABLES

CANONYMOUS BLOCK

DTRIGGER BODY

EDATABASE LINKS

Show Suggested Answer

Suggested Answer: A, E

by Brent at Apr 05, 2025, 07:40 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Titus

1 months ago

I'm betting on B) VARIABLES and D) TRIGGER BODY. Deprecated variables and triggers sounds like a great way to modernize the codebase.

upvoted 0 times

Nicolette

4 days ago

I think you're right, deprecating variables and trigger bodies can definitely help modernize the codebase.

upvoted 0 times

...

Nenita

1 months ago

This is easy! A) PACKAGES and E) DATABASE LINKS. Gotta keep that legacy code in check, right? ????

upvoted 0 times

...

Kasandra

1 months ago

Hmm, I'd say A) PACKAGES and C) ANONYMOUS BLOCK. Packages are a common target, and who uses anonymous blocks these days anyway?

upvoted 0 times

Johnathon

1 days ago

I agree, those two elements are commonly deprecated using the DEPRECATE pragma.

upvoted 0 times

...

Lisbeth

25 days ago

I think A) PACKAGES and C) ANONYMOUS BLOCK are the correct choices.

upvoted 0 times

...

Nobuko

2 months ago

I'm going with B) VARIABLES and D) TRIGGER BODY. Deprecated variables and triggers would be a way to clean up legacy code.

upvoted 0 times

Dottie

12 days ago

Deprecating anonymous blocks and trigger bodies can help in streamlining the codebase.

upvoted 0 times

...

Eileen

13 days ago

I think deprecating packages and database links would also be beneficial for code maintenance.

upvoted 0 times

...

Edgar

29 days ago

I agree, deprecating variables and trigger bodies can help in cleaning up old code.

upvoted 0 times

...

Bernadine

2 months ago

I'm not sure about trigger body, but I think variables and database links can also be deprecated.

upvoted 0 times

...

Corazon

2 months ago

I agree with Beata. Packages and trigger body make sense to deprecate.

upvoted 0 times

...

Kirk

2 months ago

I think it's A) PACKAGES and E) DATABASE LINKS. Anything involving database connectivity would be a prime target for deprecation.

upvoted 0 times

Christiane

1 months ago

I'm not sure about E) DATABASE LINKS, but I think A) PACKAGES could definitely be deprecated.

upvoted 0 times

...

Christiane

1 months ago

I agree, A) PACKAGES and E) DATABASE LINKS seem like the most likely candidates for deprecation.

upvoted 0 times

...

Beata

2 months ago

I think packages and trigger body can be deprecated.

upvoted 0 times

...