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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: dbca question

RE: dbca question

From: Koivu, Lisa <Lisa.Koivu_at_Fairfieldresorts.com>
Date: Thu, 22 May 2003 07:27:50 -0800
Message-ID: <F001.0059FF1B.20030522072750@fatcity.com>


Hi Scott, There are lots of sample schemas that can be created by the dbca. Scott is the only one that is created unlocked.

No kidding about poorly written questions...

Lisa Monkey.

-----Original Message-----
Sent: Wednesday, May 21, 2003 3:12 PM
To: Multiple recipients of list ORACLE-L

But in your quote from the Secure Configuration Guide for Oracle9iR2, it says "SCOTT" is not locked. Isn't SCOTT the sample schema? So if it isn't locked, why would they tell you to unlock it? I would probably go with "C" as well, but I think the question and answers are poorly written.

Just my $.02
-Scott

At 08:36 AM 5/21/03 -0800, you wrote:
>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?
>
>A. Create the user account and unlock the account.
>
>B. Create the user account and define a password.
>
>C. Unlock the user account and define a password.
>
>D. 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).



Scott Stefick
Systems / Oracle Certified DBA
Wm. Rainey Harper College
sstefick_at_harpercollege.edu
847.925.6130
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Stefick
  INET: sstefick_at_harpercollege.edu

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 Thu May 22 2003 - 10:27:50 CDT

Original text of this message

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