Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Database Design

Re: Database Design

From: grjohnson <Johnsog123_at_hotmail.com>
Date: 7 Jan 2004 08:37:55 -0800
Message-ID: <32b8a689.0401070837.e74c647@posting.google.com>


Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1073412899.646311_at_yasure>...
> grjohnson wrote:
>
> > andrewst_at_onetel.net.uk (Tony) wrote in message news:<c0e3f26e.0401060234.19d0ac3d_at_posting.google.com>...
> >
> >>Galen Boyer <galenboyer_at_hotpop.com> wrote in message news:<un092me58.fsf_at_standardandpoors.com>...
> >>"it does not show that you have achieved anything other
> >>than memorising the facts required to pass the exam."
> >
> >
> > You can apply the same theory to a University Degree...
>
> Perhaps at some schools. But you'd never make it past my midterms, much
> less a final, trying a stunt like that. And I can guarantee you you'd
> not have survived Dr. Carl Djerassi or numerous other profs. whose
> company I have enjoyed over the years.
>
> Here are a couple of question my students handled:
>
> 2. Create a demo showing the differences in performance inserting,
> updating, and deleting 200,000 rows in the following scenarios:
> 2A. Two heap tables with a foreign key constraint
> 2B. The same information modeled with a nested table
> 2C. The same two tables in a cluster (hash or index)
>
> 7. Create a demo procedure showing how to load an array indexed by
> binary integer and read records forward or backward depending on a
> passed parameter.
>
> Memorize away if you wish.
>
> BTW: What university did you attend?

One in which placed 50-60% weighting (out of 100% for all assesment items) on Exams, which was a real bitch for those of use without photographic memories. Received on Wed Jan 07 2004 - 10:37:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US