Re: 8i to 9i upgrade OCP sample questions

Jeff,
 There are no true accurate study exams or books. There are errors in all of them to some degree. The best you can do is practice the test questions on a database and then you will know what really happens in the database. BUT be aware that the question at test time look for the best answer and use some "fuzzy" words that can through you off. Read the questions carefully and answer the questions to the best of your knowledge.
Good luck on your test.
Ron

>>> Jeff.Eberhard_at_Rolls-RoyceGS.com 05/19/03 01:11PM >>>
Hi all,

I purchased a small study guide/practice exam for the Oracle 9i: New Features for Administrators. I have started going through it and have found
a couple of questionable questions/answers. Before I contact their support
I would like to verify my doubts. Does anyone agree with their answers.

<PRACTICE_EXAM>
You created a database by using the Database Configuration Assistant. What
must you do to access a user account in the sample schemas?

1. Create the user account and unlock the account.
2. Create the user account and define a password.
3. Unlock the user account and define a password.
4. Set the 07_DICTIONARY_ACCESSIBILITY parameter to true.

Answer: D.
</PRACTICE_EXAM>

Isn't the answer actually C? (Page 1-5 in the Oracle 9i: New Features for
Administrators Student Guide Edition 2.0 July 2002)

<PRACTICE_EXAM>
Which two are true regarding automatic space management segments? (Choose two.)

1. You can create an automatic space management segment in a dictionary-managed tablespace.
2. You can create an automatic space management segment only in a locally managed tablespace.
3. You can successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure on an automatic space management segment
4. You CANNOT successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure on an automatic space management segment.

Answer: C, D.
</PRACTICE_EXAM>

How can the can be both C and D? Don't the two statements contradict themselves or is it an "it depends" answer.

Thanks,
Jeff Eberhard

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Eberhard, Jeff
  INET: Jeff.Eberhard_at_Rolls-RoyceGS.com 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).