| 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
Darrell
Excellently put! I suspect this is why Oracle has to beta test any new tests. The original wording may be clear to the author, but ambiguous to some people. By beta testing the exam, you get the opportunity to flush out any ambiguities. One statement I heard was that a question that everyone misses isn't a good question, and one that nobody misses isn't a good question. But beta testing is expensive even if you can recruit volunteers.
I think you also make an excellent point, that if you've advanced to the point that you can argue with the author, you are probably ready to pass the test, and the practice materials have worked. I have used the Couchman practice exams and find the real exam a little easier and not as tricky.
An instructor with a lot of close experience with the exams related a story. A DBA passed a module with only one question wrong and was very angry and complained to the president of Oracle Education that he had been cheated. So they made up a special certificate saying he had passed with 100% and he went away happy. Frankly I'm not sure I'd want that person for a coworker.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Monday, May 19, 2003 3:02 PM
To: Multiple recipients of list ORACLE-L
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).
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 - 16:17:55 CDT
 |
 |