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: CREATE SESSION is required to connect to the database, and EXP_FULL_DATABASE privilege grants authority to export objects owned by any user. CREATE USER is for creating users (not exporting), CREATE ANY TABLE is for DDL (not export), IMP_FULL_DATABASE is for import (not export).

Keep practicing — related questions