Multiple choice technology programming languages

Which of the following are valid predefined roles that can be used with Oracle databases?

  1. DBA

  2. RESOURCE

  3. CONNECT

  4. EXP_FULL_DATABASE

  5. IMP_FULL_DATABASE

  6. All the above
Reveal answer Fill a bubble to check yourself
F Correct answer
Explanation

Oracle provides several predefined roles to simplify privilege management. DBA grants all system privileges, RESOURCE allows users to create objects, CONNECT allows basic database connection, EXP_FULL_DATABASE grants full export privileges, and IMP_FULL_DATABASE grants full import privileges. All of these are valid predefined roles in Oracle.

Keep practicing — related questions