Oracle 1Z0-149 Exam - Topic 14 Question 45 Discussion

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

Question #: 45
Topic #: 14

[All 1Z0-149 Questions]

Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)

AChanging the parameter setting automatically changes the setting for existing PL/SQL library units.

BThe default value is NATIVE.

CIf set to NATIVE, programs are stored in platform dependent machine code.

DIt can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.

EIf set to NATIVE, programs are stored in a PL/SQL bytecode format.

Show Suggested Answer

Suggested Answer: B

by Tasia at Jan 28, 2025, 07:06 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Stephaine

4 months ago

No way, I thought NATIVE meant bytecode format!

upvoted 0 times

...

Shaunna

4 months ago

I agree, the REUSE SETTINGS clause is super useful for recompiling.

upvoted 0 times

...

Rozella

4 months ago

Wait, programs in NATIVE are platform dependent? That’s surprising!

upvoted 0 times

...

Staci

5 months ago

I think changing the parameter doesn't affect existing libraries.

upvoted 0 times

...

Tamesha

5 months ago

The default value is definitely NATIVE.

upvoted 0 times

...

Alberta

5 months ago

I feel like option A is incorrect because changing the parameter shouldn't affect existing library units, right?

upvoted 0 times

...

Clay

5 months ago

I remember something about the REUSE SETTINGS clause, but I can't recall if it applies to this parameter.

upvoted 0 times

...

Luke

5 months ago

I'm not sure about the default value; I thought it was NATIVE too, but I might be mixing it up with another parameter.

upvoted 0 times

...

Nu

5 months ago

I think option C sounds right because if it's set to NATIVE, it should be platform dependent.

upvoted 0 times

...

Glenn

5 months ago

This is a tricky one, but I think I can work through it. I'll need to draw on my knowledge of PL/SQL and how this parameter affects the compilation and execution of the code.

upvoted 0 times

...

Katie

5 months ago

I'm feeling pretty confident about this one. I remember learning about the PLSQL_CODE_TYPE parameter and the implications of the different settings. I'll mark the two correct options.

upvoted 0 times

...

Margret

5 months ago

Okay, I think I've got a handle on this. The key is to focus on the differences between the settings and what they mean for how the PL/SQL code is stored and executed.

upvoted 0 times

...

Carman

5 months ago

Hmm, I'm a bit confused by the wording of some of these options. I'll need to make sure I understand the differences between NATIVE and other settings for this parameter.

upvoted 0 times

...

Octavio

6 months ago

This looks like a tricky question about a PL/SQL parameter. I'll need to carefully read through the options and think about what I know about this parameter.

upvoted 0 times

...

Bambi

10 months ago

I'm just going to ask Alexa for the answer. She probably knows more about PL/SQL than I do at this point. 'Alexa, what are the two true statements about the PLSQL_CODE_TYPE parameter?'

upvoted 0 times

...

Berry

10 months ago

Hmm, I'm not sure about the recompiling part. Do I need to sacrifice a goat to the Oracle gods to get my code to recompile without changing the settings? Better bring some incense just in case.

upvoted 0 times

Cary

9 months ago

Jody: Got it, thanks for the clarification!

upvoted 0 times

...

Jody

9 months ago

User 3: Bettyann is right, you can recompile without changing settings with REUSE SETTINGS.

upvoted 0 times

...

Bettyann

9 months ago

User 2: So, changing the parameter setting doesn't automatically change existing units?

upvoted 0 times

...

Rasheeda

10 months ago

User 1: Don't worry, you don't need to sacrifice a goat. Just use the REUSE SETTINGS clause.

upvoted 0 times

...

Deandrea

10 months ago

This question is a bit tricky, but I think I got it. B and C are true - the default is NATIVE, and that means the code is stored in machine code. Time to brush up on my assembly language!

upvoted 0 times

...

Brande

11 months ago

Whoa, hold on! If I set PLSQL_CODE_TYPE to NATIVE, does that mean my code will be running on a hamster on a wheel? I need to know the power consumption of my PL/SQL programs!

upvoted 0 times

Alyssa

9 months ago

E) If set to NATIVE, programs are stored in a PL/SQL bytecode format.

upvoted 0 times

...

Mitsue

9 months ago

C) If set to NATIVE, programs are stored in platform dependent machine code.

upvoted 0 times

...

Theodora

9 months ago

A) Changing the parameter setting automatically changes the setting for existing PL/SQL library units.

upvoted 0 times

...

Penney

11 months ago

C and D seem to be the correct answers. Changing the PLSQL_CODE_TYPE parameter won't affect existing units, and NATIVE means platform-dependent machine code, not bytecode.

upvoted 0 times