leostar10 wrote:
> Hi,
> Iam new to Oracle and would appreciate any clarifications on
> these doubts I have:
>
> 1. Iam reading the documentation and it says that Oracle DB Server is
> basically Oracle Database and Oracle instance. What I understand is
> there is one Oracle DB and there can be 1 or more Oracle instances. So
> my question is, when can there be more than one Oracle instances?
>

RAC


> 2. Is there always a one-to-one relationship between a schema name and
> the username?

Yes
>
> 3. Can the actual data corresponding to a Schema be in one datafile or
> it can be shared in more than one datafiles and also can a datafile
> contain the information pertaining to more than one schemas?

You set the user/schema to have a default tablspace that can have more
that one datafile. Multiple users can use the same tablespace, so yes.

>
> Thanks!