Which three statements are true about the users (other than sys) in the output?

Examine the query and its output executed In an RDBMS Instance:

Which three statements are true about the users (other than sys) in the output?

Examine the query and its output executed In an RDBMS Instance:

Which three statements are true about the users (other than sys) in the output?

A.
The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.

B.
The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.

C.
The C # # A_ADMIN user can perform wallet operations.

D.
The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage
Management (ASM).

E.
The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or
SQL* Plus.

Explanation:

B: SYSDG administrative privilege has ability to perform Data Guard operations (including startup
and shutdown) using Data Guard Broker or dgmgrl.
D: SYSASM
The new (introduced in 11g) SYSASM role to manage the ASM instance, variable extent sizes to
reduce shared pool usage, and the ability of an instance to read from a specific disk of a diskgroup
E (Not A): SYSDBA is like a role in the sense that it is granted, but SYSDBA is a special built-in
privilege to allow the DBA full control over the database
Incorrect:
Not C: SYSKM. SYSKM administrative privilege has ability to perform transparent data encryption
wallet operations.

Note:
Use the V$PWFILE_USERS view to see the users who have been granted administrative
privileges.



Leave a Reply 4

Your email address will not be published. Required fields are marked *


conversational tone

conversational tone

Truly no matter if someone doesn’t understand after that its up to other visitors that they will help, so here it happens.|