Multiple choice

How is the HR_PAY role enabled?

  1. SET ROLE hr_pay;

  2. CREATE ROLE hr_pay;

  3. ENABLE ROLE hr_pay;

  4. SET ENABLE ROLE hr_pay;
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The SET ROLE command enables a role in the current session. Option A shows the correct syntax. CREATE ROLE creates a new role, it doesn't enable it. ENABLE ROLE is not valid Oracle syntax. SET ENABLE ROLE is not a valid command - only SET ROLE or SET ROLE ALL are valid.

Keep practicing — related questions