Oracle Exam 1Z0-071 Topic 14 Question 95 Discussion

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

Question #: 95
Topic #: 14

[All 1Z0-071 Questions]

Which three are true aboutprivileges and roles?

ASystem prilgese always set prilge for an entire database.

BPUBLIC acts as a default role granted to every user in a database.

CA user has all object privileges for every object in their schema by default.

DA role can contain a combination of several privileges and roles.

EA role is owned by the user who created it.

FAll roles are owned by the sYs schema.

GPUBIIC can be revoked from a user.

Show Suggested Answer

Suggested Answer: C, D

by Vicente at Jun 23, 2024, 05:20 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Desire

1 months ago

I'm going with D, F, and G. A role can have multiple privileges, PUBLIC can be revoked, and it is a default role. Easy peasy!

upvoted 0 times

...

Haha, I bet option B is a trap question. System privileges are usually more granular than that. And who would ever want to revoke PUBLIC from a user? What are they, some kind of database supervillain?

upvoted 0 times

Winfred

9 days ago

G) PUBLIC acts as a default role granted to every user in a database

upvoted 0 times

...

Stephaine

11 days ago

E) A user has all object privileges for every object in their schema by default.

upvoted 0 times

...

Denise

12 days ago

A) A role is owned by the user who created it.

upvoted 0 times

...

Cornell

2 months ago

I'm not sure about option C. I thought roles could be owned by any user, not just SYS. And option E seems a bit too broad - users don't get all object privileges by default, right?

upvoted 0 times

Rodney

8 days ago

Option E is also incorrect. Users do not have all object privileges by default.

upvoted 0 times

...

Polly

10 days ago

You're right, roles can be owned by any user, not just SYS.

upvoted 0 times

...

Una

13 days ago

Option C is incorrect. Roles can be owned by any user, not just SYS.

upvoted 0 times

...

Norah

2 months ago

I think options D and G are the correct answers here. A role can definitely contain a combination of privileges and other roles, and PUBLIC is a default role granted to all users in a database.

upvoted 0 times

Rosita

27 days ago

Great, we've got it figured out then. D and G it is.

upvoted 0 times

...

Yuriko

1 months ago

That makes sense. So, D and G are the correct answers for this question.

upvoted 0 times

...

Stephania

1 months ago

Yes, that's true. And I think option G is also correct. PUBLIC is granted to every user by default.

upvoted 0 times

...

Krystal

2 months ago

I agree, option D is correct. A role can indeed contain a combination of privileges and roles.

upvoted 0 times

...

Hoa

2 months ago

I'm not sure about E. Can someone explain why a user has all object privileges by default?

upvoted 0 times

...

Bobbye

2 months ago

I agree with Michael. A role can definitely contain a combination of privileges and roles.

upvoted 0 times

...

Michael

3 months ago

I think A, D, and G are true.

upvoted 0 times

...

Oracle Exam 1Z0-071 Topic 14 Question 95 Discussion

Contribute your Thoughts:

Desire

Judy

Winfred

Stephaine

Denise

Cornell

Rodney

Polly

Una

Norah

Rosita

Yuriko

Stephania

Krystal

Hoa

Bobbye

Michael