Examine this output: Which three are true?

Question

Options

• AJohn must connect as system to perform backup and recovery operations.
• BJohn can query dba tables.
• CJohn can perform backup and recovery operations by using SQL.
• DJohn can perform backup and recovery operations by using RMAN.
• EJohn must connect as sys to perform backup and recovery operations.
• FJohn Is not able to perform startup and shutdown operations.
• GJohn can query other user's data.

• A
  88% (23)
• D
  4% (1)
• E
  8% (2)

Explanation

Based on the (unseen) output, John has been granted the DBA role - a powerful but non-SYSDBA level of access in Oracle Database. This role grants him full read access to the data dictionary (DBA_* views), making B correct, and the SELECT ANY TABLE system privilege, making G correct. For backup and recovery, John lacks the SYSDBA or SYSOPER system privilege, so he must authenticate through the built-in SYSTEM account to perform those operations - confirming A is correct.

Why the distractors are wrong:

• C is wrong because Oracle backup is not performed via SQL statements - that's not how the architecture works.
• D is wrong because RMAN requires SYSDBA or SYSOPER privilege, which John's DBA role does not include.
• E is wrong because SYS and SYSTEM are distinct accounts - SYS owns the data dictionary and requires SYSDBA; SYSTEM is the correct DBA-level account for this scenario.
• F is wrong because a user with DBA-level credentials (via SYSTEM) retains startup/shutdown capability.

Memory tip: Think of it as a "DBA sandwich" - John gets the bread (query DBA tables, query user data) but not the filling (SYSDBA/SYSOPER). For backup, he borrows the kitchen (SYSTEM account), not the master chef's tools (SYS/SYSDBA).

No community discussion yet for this question.