Re: Good Interview Question on Oracle

From: Steve Phelan <stevep_at_pmcgettigan.demon.co.uk>
Date: 1997/03/10
Message-ID: <332407E4.6AC@pmcgettigan.demon.co.uk>#1/1

Atif Ahmad Khan wrote:
>
> I wonder if anyone knows this.
>
> What would happen if you were to install Oracle from scratch with default
> values and then created a table and tried to enter 2.5mil records into it ?
>
> This is an easy one. Anyone who has ever installed Oracle and played with
> a little should know the answer to this one.
>
> Atif Khan
> aak2_at_ra.msstate.edu

You mean, running out of extents or tablespace? (i.e., hitting max_extents or filling the SYSTEM tablespace).

Of course, if you'd installed Oracle 7.3 and chosen to make a large database and created your table with unlimited extents and let your datafiles auto extend and chosen a specific tablespace for the creation...

Like you said, interesting question - one which raises more questions than it answers! :-) Still, these can be good questions, used to open a more prolonged discussion about Oracle Architecture in an interview. In other words, don't ask questions which have one - and only one - answer.

Steve Phelan. Received on Mon Mar 10 1997 - 00:00:00 CST