Oracle Exam 1Z0-149 Topic 15 Question 28 Discussion

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

Question #: 28
Topic #: 15

[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 Tu at Jun 02, 2024, 04: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

Laura

5 months ago

I'm going to have to go with A and D. Why would we need to specify the ACCESSIBLE BY clause in the package spec or body? That's just overkill, don't you think?

upvoted 0 times

Gail

4 months ago

True, but it can still be a bit overkill in some cases.

upvoted 0 times

...

Eun

4 months ago

But it enforces the check for direct access and dynamic SQL.

upvoted 0 times

...

Ben

5 months ago

I agree, specifying it in the package spec or body seems unnecessary.

upvoted 0 times

...

Annice

5 months ago

I think A and D are correct. It's useful for object types and individual procedures.

upvoted 0 times

...

Felicitas

5 months ago

C and D, for sure! The ACCESSIBLE BY clause checks both direct access and access through dynamic SQL. It's like a bouncer at a club, making sure only the right people get in.

upvoted 0 times

...

Regenia

5 months ago

Wait, isn't the ACCESSIBLE BY clause used to control access to databases, not Oracle packages? I'm so lost right now.

upvoted 0 times

Levi

4 months ago

C) The check is enforced by this clause for direct access and access through dynamic SQL.

upvoted 0 times

...

Chanel

5 months ago

A) It can be used in the declaration of object types.

upvoted 0 times

...

Peggie

6 months ago

Hmm, I'm pretty sure B and E are the right answers. The ACCESSIBLE BY clause must be specified in the package specification and body, not individual procedures or functions.

upvoted 0 times

Roosevelt

5 months ago

User 2

upvoted 0 times

...

Rory

5 months ago

User 1

upvoted 0 times

...

Delisa

6 months ago

I think the correct answers are C and D. The ACCESSIBLE BY clause is used to restrict access to procedures and functions in a package, not for object types.

upvoted 0 times