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?

Question

Exhibit

Options

• AThe C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.
• BThe C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
• CThe C # # A_ADMIN user can perform wallet operations.
• DThe C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage
• EThe C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL*

• A
  11% (3)
• B
  86% (24)
• C
  4% (1)

Explanation

B: SYSDG administrative privilege has ability to perform Data Guard operations (including startup and shutdown) using Data Guard Broker or dgmgrl. 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 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 Not C: SYSKM. SYSKM administrative privilege has ability to perform transparent data encryption wallet operations. Use the V$PWFILE_USERS view to see the users who have been granted administrative

No community discussion yet for this question.