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: SYSASMThe 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.