Re: Selftest Software OCP Prep tests

Alex, you are right in terms of the question -- when you start an Instance, you do only read the parameter file, allocate SGA, start background processes and open trace and ALERT files.
I was just thinking from a Unix/Svrmgr perspective, if you issue the command svrmgr> startup -- you are opening the database.

However, the answer is correct in that starting the Instance is different. (no, my brain isn't overloaded, either :-)).
Guess I was reading into the question incorrectly, and then the explanations for the answer made it appear they weren't giving the correct choices.

I'm ready to save some face, so send away :-))

Alexander Kornacki wrote:

> Hi,
>
> Hello, who wrote:
>
> > Altho there are a couple of errors in their questions.
>
> Sure, there are some errors, but I believe not in your case.
>
> > One Example:
> >
> > Question:
> > Which three steps should you complete before issuing the CREATE DATABASE
> > command? (Choose three).
> >
> > A. Connect as SYSDBA
> > B. Start up an instance.
> > C. Create a control file.
> > D. Create a database user.
> > E. Create a parameter file
> > F. Start an instance and MOUNT the database.
> >
> > Now, to me, from these selections there are only two correct answers: A and E
> > However, they also claim that the third correct answer is B, start up and
> > instance.
>
> Sure, I would pick A, B and E.
>
> > I believe this answer is incomplete, because to create a database, you should
> > start in the NOMOUNT state. They should be more specific.
>
> starting an instance exactly means starting NOMOUNT.
> when you start MOUNT, you mount the database.
> when you start OPEN, you open it then.
>
> Even on the Instance Manager Status panel( with that traffic lights), you
> can spot four database states:
> - Shutdown
> - Instance started
> - Database mounted
> - Database open
>
> They are consistent enough with this in their docs, and I can't see
> why I shouldn't start an instance before issuing "CREATE DATABASE".
>
> > Even in their explanations, they say Startup the instance in NOMOUNT state --
> > not the same as the actual choice they give you.
> >
> > For these reasons, buyer beware and STUDY STUDY STUDY!!
>
> And don't overload you brain!!!
>
> I will come back soon with my own questions, you will have a couple of chances
> to revenge.
>
> Alex.
Received on Mon Feb 07 2000 - 12:02:32 CST