Oracle
1Z0-072 · Question #37
Which two are true about users who are granted SYSDBA or SYSOPER privileges? (Choose two.)
The correct answer is B. Users granted SYSDBA can take a complete backup of a database. See the full explanation below for the reasoning.
Question
Which two are true about users who are granted SYSDBA or SYSOPER privileges? (Choose two.)
Options
- AOnly users granted SYSDBA can query or update tables in all user schemas.
- BUsers granted SYSDBA can take a complete backup of a database.
- CUsers granted either SYSDBA or SYSOPER connect to an instance as SYS.
- DUsers granted either SYSDBA or SYSOPER can mount or open a database.
- EOnly users granted SYSDBA can start up and shut down a database instance.
- FUsers granted either SYSDBA or SYSOPER can query data in all user schemas.
How the community answered
(39 responses)- B72% (28)
- C5% (2)
- D5% (2)
- E15% (6)
- F3% (1)
Community Discussion
No community discussion yet for this question.