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.
BDE
Why E:
SYSBACKUP facilitates Oracle Recovery Manager (RMAN) backup and recovery operations either from RMAN or SQL*Plus.
https://docs.oracle.com/database/121/ADMIN/dba.htm#ADMIN11042
B D E
Truly no matter if someone doesn’t understand after that its up to other visitors that they will help, so here it happens.|
B C E