Oracle Database Administration II — Question 110

Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege? (Choose three.)

Answer options

• A. They can view data from any data dictionary view or dynamic performance view.
• B. They cannot create restore points.
• C. They cannot drop tablespaces.
• D. They can create any table.
• E. They can drop any tablespace.
• F. They can view data from any user-defined tables.

Correct answer: C, D

Explanation

The correct answers are C and D because users with the SYSBACKUP privilege are not allowed to drop tablespaces (C) but they can create any table (D). Options A, B, E, and F are incorrect as they either misrepresent the capabilities of SYSBACKUP users or state actions they are not restricted from performing.