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

• ATheC# # B_ADMIN user can perform all back up and recovery operation susing 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

• A
  15% (5)
• B
  79% (27)
• C
  6% (2)

Explanation

Options B, D, and E are correct because they accurately describe the capabilities of Oracle's limited administrative privilege roles: SYSDG (C##C_ADMIN) allows Data Guard operations including interaction with Data Guard Broker; SYSASM (C##D_ADMIN) grants privileges specifically for Automatic Storage Management operations; and SYSBACKUP (C##B_ADMIN) permits backup and recovery operations via both RMAN and SQL*Plus - not RMAN exclusively.

Why A is wrong: It incorrectly restricts the SYSBACKUP role to RMAN only. SYSBACKUP also permits operations through SQL*Plus, which is precisely what makes E the correct version of that statement.

Why C is wrong: Wallet and Transparent Data Encryption key management operations require the SYSKM role. The query output indicates C##A_ADMIN does not hold SYSKM - it holds a different administrative role, so the wallet operations claim is false for that user.

Memory tip: Map each role to its domain using the mnemonic "BDK-G" - BACKUP=SYSBACKUP, Data Guard=SYSDG, Key/wallet=SYSKM, Grid/ASM=SYSASM. When a question pairs a user with an operation, verify both that the user holds the matching role and that the described capability is complete (e.g., SYSBACKUP covers RMAN and SQL*Plus, not one tool alone).

No community discussion yet for this question.