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

Jacquelyne

2 months ago

They should've just called them 'SYSDUDE', 'SYSBRUH', and 'SYSKEWL' for a more relatable experience.

upvoted 0 times

Denise

11 days ago

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

upvoted 0 times

...

Cyndy

12 days ago

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

upvoted 0 times

...

Jenelle

16 days ago

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

upvoted 0 times

...

Jerilyn

2 months ago

Hold on, these privileges are supposed to make our lives easier, not more complicated. I hope the correct answer doesn't involve a bunch of obscure requirements.

upvoted 0 times

...

Ronald

2 months 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

Luisa

19 days ago

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

upvoted 0 times

...

Cornell

21 days ago

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

upvoted 0 times

...

Eleni

28 days ago

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

upvoted 0 times

...

Marla

2 months 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

2 months 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

2 months 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

Rhea

1 months ago

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

upvoted 0 times

...

Oretha

2 months ago

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

upvoted 0 times

...

Iluminada

2 months ago

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

upvoted 0 times

...

Willis

2 months ago

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

upvoted 0 times

...