nerdexam
Oracle

1Z0-072 · Question #39

Which two are true about the roles? (Choose two.)

The correct answer is A. All privileges and roles granted to a user are enabled by default when the user logs in. See the full explanation below for the reasoning.

Question

Which two are true about the roles? (Choose two.)

Options

  • AAll privileges and roles granted to a user are enabled by default when the user logs in.
  • BThe SET ROLE statement can be used once per session.
  • CThe SET ROLE statement enables as well as disables roles in a session.
  • DA role must be disabled before it can be revoked from a user.
  • EThe ALTER USER statement must be used to set specific default roles for a user.

How the community answered

(32 responses)
  • A
    75% (24)
  • B
    6% (2)
  • C
    16% (5)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-072 Practice