RE: dbca question

From: Koivu, Lisa <Lisa.Koivu_at_Fairfieldresorts.com>
Date: Wed, 21 May 2003 08:36:41 -0800
Message-ID: <F001.0059EED0.20030521083641@fatcity.com>

Was just reading this. From the "Secure Configuration Guide for Oracle9iR2":

"The DBCA automatically locks and expires all default database user accounts except SYS, SYSTEM, SCOTT and DBSNMP upon the successful creation of a database server instance."

So that question is unclear. I would answer C.

The answer in D is very dangerous.

I highly suggest reading through this document. Lots of important information.

It is so good to be back into this stuff again...!!!!!

Lisa Koivu
Oracle Database MONKEY
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
Office: 954-935-4117
Fax: 954-935-3639
Cell: 954-683-4459

-----Original Message-----
Sent: Wednesday, May 21, 2003 11:02 AM
To: Multiple recipients of list ORACLE-L

Hi list , I came across a question while preparing for my exam

QUESTION : 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.

--

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

Author: <bulbultyagi_at_now-india.net.in
  INET: bulbultyagi_at_now-india.net.in

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: Koivu, Lisa
  INET: Lisa.Koivu_at_Fairfieldresorts.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). Received on Wed May 21 2003 - 11:36:41 CDT