This discussion is archived
4 Replies Latest reply: Jun 20, 2013 2:06 PM by rp0428 RSS

Multiple SCHEMA under a single USER, Multiple USERs associated to a single SCHEMA

9b631776-4fa1-4f58-89e1-7d700432a1fc Newbie
Currently Being Moderated



Please can you confirm which statements are true and which are false.


  1. A USER can have only one SCHEMA.
  2. A USER can have zero to many SCHEMAs.
  3. A USER can have one to many SCHEMAs.


  1. A SCHEMA can be owned by zero to many USERs.
  2. A SCHEMA can be owned by one to many USERs.
  3. A SCHEMA must be owned by one and only one USERs.


USER in this case means Database Object.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points