Oracle Exam 1Z0-149 Topic 2 Question 37 Discussion

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

Question #: 37
Topic #: 2

Examine this statement which is submitted for compilation:

Which three are true? (Choose three.)

AThis is a PACKAGE specification. A PACKAGE BODY is needed to use this.

BThis will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.

CThis program unit will compile successfully.

DInitialization of min_bal can be done while using this packaged constant in another program.

EInitialization of loan_amount can be done while using this packaged variable in another program.

FThis will not compile successfully because the min_bal constant must be initialized.

GThis is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.

Show Suggested Answer

Suggested Answer: B, F, G

by Lawanda at Sep 18, 2024, 04:09 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Fannie

7 months ago

Wait, is this a trick question? I feel like I'm being set up for failure here. Time to sharpen my Oracle skills!

upvoted 0 times

...

Amie

7 months ago

G is the hidden gem here. This is a bodiless package, so a package body is not required to use it. Clever!

upvoted 0 times

Rossana

6 months ago

User 3: So, we can use the package without the extra overhead of a package body. Nice!

upvoted 0 times

...

Tonette

6 months ago

User 2: I agree, that's a clever design choice.

upvoted 0 times

...

Avery

6 months ago

G is definitely the key here. No need for a package body with a bodiless package.

upvoted 0 times

...

Kara

7 months ago

D and E are also correct. The initialization of min_bal and loan_amount can be done while using these packaged entities in another program.

upvoted 0 times

Ilona

6 months ago

E) Initialization of loan_amount can be done while using this packaged variable in another program.

upvoted 0 times

...

Paz

6 months ago

D) Initialization of min_bal can be done while using this packaged constant in another program.

upvoted 0 times

...

Estrella

7 months ago

A) This is a PACKAGE specification. A PACKAGE BODY is needed to use this.

upvoted 0 times

...

Veronika

7 months ago

But the statement clearly mentions that the loan_amount variable is declared NOT NULL, so option B cannot be true.

upvoted 0 times

...

Stanton

7 months ago

C seems right to me. This program unit will compile successfully.

upvoted 0 times

Sylvie

6 months ago

I believe G is correct. It's a BODILESS PACKAGE, so no PACKAGE BODY is required.

upvoted 0 times

...

Fletcher

6 months ago

I think A is also true. A PACKAGE BODY is needed to use this.

upvoted 0 times

...

Bea

7 months ago

I agree, C is correct. The program will compile successfully.

upvoted 0 times

...

Heike

7 months ago

I disagree, I believe options A, B, and F are the correct ones.

upvoted 0 times

...

I think B and F are the correct answers. The variable loan_amount is declared as NOT NULL but lacks an initialization assignment, and the constant min_bal must be initialized in the package specification.

upvoted 0 times

Mozell

7 months ago

F) This will not compile successfully because the min_bal constant must be initialized.

upvoted 0 times

...

Vi

7 months ago

B) This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.

upvoted 0 times

...

Reta

7 months ago

A) This is a PACKAGE specification. A PACKAGE BODY is needed to use this.

upvoted 0 times

...

Veronika

7 months ago

I think options A, D, and E are true.

upvoted 0 times

...

Oracle Exam 1Z0-149 Topic 2 Question 37 Discussion

Contribute your Thoughts:

Fannie

Amie

Rossana

Tonette

Avery

Kara

Ilona

Paz

Estrella

Veronika

Stanton

Sylvie

Fletcher

Bea

Heike

Lynette

Mozell

Vi

Reta

Veronika