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

Hi,

 

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.

Legend

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