nerdexam
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)
  • B
    72% (28)
  • C
    5% (2)
  • D
    5% (2)
  • E
    15% (6)
  • F
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-072 Practice