RE: 8i to 9i upgrade OCP sample questions

From: Regis Biassala <Regis.Biassala_at_datalex.ie>
Date: Mon, 19 May 2003 10:06:45 -0800
Message-ID: <F001.0059CBD6.20030519100645@fatcity.com>

The answer should be C
C. Unlock the user account and define a password.

The other one is weird....

Regis

-----Original Message-----
Sent: Monday, May 19, 2003 6:12 PM
To: Multiple recipients of list ORACLE-L

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).

---

This electronic transmission is strictly confidential and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender as soon as possible.

This footnote also confirms that this message has been swept for computer viruses.

---

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Regis Biassala
  INET: Regis.Biassala_at_datalex.ie

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). Received on Mon May 19 2003 - 13:06:45 CDT