Re: OCP 8 Question on Objects

You are correct.

Of course the question is yet another example of a very bad question -

If you choose to create a table of type photo-album you get two indexes. One is for the unique object identifier, the other is the LOB INDEX identifying the bits of the lob_segment that belong to a specific BLOB. Which one do you think the examiner was thinking of ?

There are several other hairs to split about the quality of the question. But one howler is enough for this evening.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Buck Turgidson wrote in message
<1w6B4.8672$iP.654418_at_bgtnsc04-news.ops.worldnet.att.net>...


>I am presented with the following question.  The correct answer supposedly

>is C, which I find surprising.  I would say D, since at this point, all

>you've created is a type, and have not created any segments or allocated

>storage.  Unfortunately, I don't have the objects option to test this.

>

>Opinions?

>

>

>----------------

>Evaluate this command:

>CREATE TYPE photo_album AS OBJECT

>(photo_image BLOB);

>

>An index on the PHOTO_IMAGE image colum must exist to find the actual

 value.


>How will this index be created?

>

>A.    Explicitly with the CREATE LOB KEY command

>B.    Explicitly with the CREATE LOB INDEX command

>C.    Implicitly when this command executes successfully

>D.    Implicitly when the object type is used to define an object table.

>

>