Oracle Exam 1Z0-149 Topic 9 Question 41 Discussion

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

Question #: 41
Topic #: 9

[All 1Z0-149 Questions]

Which two are true about using the ACCESSIBLE BY clause? (Choose two.)

AIt can be used in the declaration of object types.

BIt must be specified in the heading of a package specification.

CThe check is enforced by this clause for direct access and access through dynamic SQL.

DIt can be used for individual procedures and functions declared in a package specification.

EIt must be specified in the heading of a package body.

Show Suggested Answer

Suggested Answer: A, D

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

by Arminda at Oct 23, 2024, 08:46 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Mitzie

1 months ago

This is a classic Oracle question. I remember the ACCESSIBLE BY clause from my days as a junior DBA. Good thing I brushed up on my package knowledge before the exam!

upvoted 0 times

Denae

6 days ago

Which two are true about using the ACCESSIBLE BY clause? (Choose two.)

upvoted 0 times

...

Maurine

14 days ago

Which two are true about using the ACCESSIBLE BY clause? (Choose two.)

upvoted 0 times

...

Ha! I bet the people who write these exam questions have a secret competition to see who can come up with the most confusing wording. As long as you know your stuff, you'll be fine. I'm going with C and D.

upvoted 0 times

...

Jackie

1 months ago

I disagree, I believe C and E are the correct options.

upvoted 0 times

...

Mable

1 months ago

I'm not sure about option E. Isn't the package specification where you declare the public interface, and the package body is where you implement the actual logic? I'm pretty sure the ACCESSIBLE BY clause goes in the specification, not the body.

upvoted 0 times

Julianna

1 days ago

Yes, that's correct. It helps control access to the objects in the package.

upvoted 0 times

...

Lashaunda

6 days ago

I think you're right, the ACCESSIBLE BY clause should go in the package specification.

upvoted 0 times

...

Geraldo

1 months ago

I think A and D are true about using the ACCESSIBLE BY clause.

upvoted 0 times

...

Rosalyn

2 months ago

I think options C and D are the correct answers. The ACCESSIBLE BY clause is used to restrict access to specific procedures and functions within a package, and it applies to both direct access and dynamic SQL.

upvoted 0 times

Andrew

12 days ago

I think you're right. Options C and D make the most sense when it comes to the ACCESSIBLE BY clause.

upvoted 0 times

...

Dorinda

25 days ago

I see your point, but I still think options C and D are the correct ones. It enforces the check for direct access and dynamic SQL.

upvoted 0 times

...

Rossana

1 months ago

I think it's actually options A and D. The clause can be used in the declaration of object types as well.

upvoted 0 times

...

Iluminada

1 months ago

I agree, options C and D are correct. The clause restricts access to specific procedures and functions.

upvoted 0 times

...

Oracle Exam 1Z0-149 Topic 9 Question 41 Discussion

Contribute your Thoughts:

Mitzie

Denae

Maurine

Timmy

Jackie

Mable

Julianna

Lashaunda

Geraldo

Rosalyn

Andrew

Dorinda

Rossana

Iluminada