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

Cornell

4 days 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

...

Norah

5 days 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

...