| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: 8i to 9i upgrade OCP sample questions
Jeff,
You're encountering what is a very, very common issue with 'practice exam' material. I've seen practice exams with erroneous answers for Novell, MCSE, SQL Server, and for Oracle 8i. Usually, there aren't too many (just a guess - maybe 1 or 2 for every 50 questions), so they shouldn't be too much of a hindrance to being prepared for the real exam. I was able to go on and pass all of the certifications I mentioned, but still it can be kind of annoying, if not scary especially since the 'exam guide' doesn't always explicitly answer the question either. Understandably folks will make mistakes, but publishers really need to put more effort into quality control of practice test books and software (especially since these things are so expensive and usually purchased by individuals like you and me and not corporations). It could get interesting if we all started sharing our experiences of inadequate certification material and help steer future candidates toward the better material.
It looks like the free_blocks procedure is likely a 'no-go' for assm segments. Blocks in assm segments are maintained by bitmaps and not freelists. The dbms_space.free_blocks procedure takes as an input, the freelist_group_id.
SQL> desc dbms_space
PROCEDURE FREE_BLOCKS
Argument Name Type In/OutDefault?
On the other question, 07_DICTIONARY_ACCESSIBILITY is related to enabling the 'ANY' privileges. Prior to 9i it was TRUE by default and now is FALSE by default. I agree with a previous response that the correct answer there is actually C.
Good luck with your tests!!
>>> Jeff.Eberhard_at_Rolls-RoyceGS.com 05/19/03 12: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?
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.)
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: Darrell Landrum INET: DLANDRUM_at_zalecorp.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 Mon May 19 2003 - 15:02:07 CDT
 |
 |