Multiple choice technology databases

Which two roles or privileges must you have to export tables owned by another user? (Choose two)

  1. CREATE USER

  2. CREATE SESSION

  3. CREATE ANY TABLE

  4. IMP_FULL_DATABASE

  5. EXP_FULL_DATABASE
Reveal answer Fill a bubble to check yourself
B,E Correct answer
Explanation

To export tables owned by another user, you must have the CREATE SESSION privilege to connect to the database and the EXP_FULL_DATABASE role to export objects belonging to other schemas.

Keep practicing — related questions