Oracle Exam 1Z0-497 Topic 2 Question 75 Discussion

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

Question #: 75
Topic #: 2

Oracle Database 12c provides new task-specific privileges (SYSBACKUP, SYSDG, and SYSKM) to handle standard administration duties. Which two statements about these standard administration privileges are true?

AThese administrative privileges enable you to connect to the database only if the database is open.

BAfter connecting with these privileges, you are connected under a predefined user whose name is the privilege name.

CThese administrative privileges allow a user to view DBA_xxx, GV$, VS, and SELECT on application tables.

DWithout being a member of OSBACKUP. OSDG, and OSKM OS groups, users cannot connect as administrative users by using OS authentication.

Show Suggested Answer

Suggested Answer: C, D, F

by Rhea at May 29, 2023, 11:05 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Ronald

2 days ago

Option D sounds a bit off. Surely I don't need to be part of some special OS group to use these privileges? That would be a pain to manage.

upvoted 0 times

...

Marla

5 days ago

Hmm, I think option B is correct. These privileges connect you as a predefined user with the same name as the privilege, right? That makes sense for security and auditing purposes.

upvoted 0 times

...

Laurel

14 days ago

I'm not sure about option A. It seems like it might be true, but I need to double-check the details.

upvoted 0 times

...

Lisbeth

16 days ago

I'm pretty sure that's not how the new administrative privileges work. Didn't they introduce these to provide more granular control over database administration tasks?

upvoted 0 times

Oretha

3 days ago

A) These administrative privileges enable you to connect to the database only if the database is open.

upvoted 0 times

...

Iluminada

16 days ago

I agree with Willis. Option B makes sense as it specifies the user being connected under a predefined name.

upvoted 0 times

...

Willis

18 days ago

I think option B is true because it mentions connecting under a predefined user.

upvoted 0 times

...