Message-Id: <10577.113662@fatcity.com> From: "Grabowy, Chris" Date: Wed, 2 Aug 2000 18:17:54 -0400 Subject: RE: Help needed: OCP exam_cram book questons So whatever happend to actually learning this stuff versus cramming for a test... -----Original Message----- From: Cyril Thankappan [mailto:cyril_thank@india.com] Sent: Wednesday, August 02, 2000 4:48 PM To: Multiple recipients of list ORACLE-L Subject: Re: Help needed: OCP exam_cram book questons Hi! Oops u mean I should not have 'thrown out' those cram books? ie cram is good for clearing OCP? ------Original Message------ To: Multiple recipients of list ORACLE-L Sent: July 31, 2000 10:05:48 AM GMT you study the cram exam books or take the tests or guess right >From: Cyril Thankappan >Reply-To: ORACLE-L@fatcity.com >To: Multiple recipients of list ORACLE-L >Subject: Re: Help needed: OCP exam_cram book questons >Date: Sun, 30 Jul 2000 21:45:04 -0800 > >Hi! > >Thanks Rachel for the 'insight'.. > >But can u help me! > >Where can I get the 'scoring answers' (answers which >will get me marks!) > >Thanks > >------Original Message------ >To: Multiple recipients of list ORACLE-L >Sent: July 31, 2000 3:04:00 AM GMT > > >The problem is, you can't necessarily understand the correct answer. >Because >the "correct" answer is not always the one that is really right. > >Oracle has decided that these are the answers. So they are the correct >ones, >even if you think they are wrong. > >I have a friend who finally managed to pass the Performance Tuning exam by >answering questions deliberately wrong -- because she knew that the "wrong" >answer was the one Oracle wanted on the exam. > > >From: "Guang Mei" > >Reply-To: ORACLE-L@fatcity.com > >To: Multiple recipients of list ORACLE-L > >Subject: Help needed: OCP exam_cram book questons > >Date: Sun, 30 Jul 2000 15:24:44 -0800 > > > >Hi: > > > >I was reading the OCP review book "EXAM_CRAM" (author: Michael Ault) and > >have a few questions about the sample test questions. I would like to >know > >the "coorect" answer and understand why. > > > >Here it goes: > > > >------------------- > >Question 27: > > > >You query the database with this command: > > > >SELECT > >CONCAT(LOWER(SUBSTR(description,10)), > >LENGTH(product_name)) "Product ID" > >FROM inventory; > > > >Which function is evaluate second? > >a CONCAT() > >b. LOWER() > >c. SUBSTR() > > > >According to the book: > >The correct answer is c. Answer a is incorrect because CONCAT() is >outside > >of the parantheses. Answer b is incorrect because LOWER() is not inside >the > >innermost parentheses. > > > > > >I thought the answer should be b. Why am I wrong here? > > > >------------------- > >Question 39: > > > >What is the purpose of the PL/SQL FETCH command? > > > >a. To define a cursor to be used later > >b. To retrieve values from the active set into local variables > >c. To call the rows identified by a cursor query into the active set > >d. To relase the memory used by the cursor > > > >According to the book: > >The correct answer is c. The fETCH command retrieve values returned by >the > >cursor into the active set. Answer a is incorrect because this statement >is > >the function of the CURSOR command. Answer b is incorrect because this is > >the function of OPEN command. Answer d is incorrect because this is the > >function of the CLOSE command. > > > >I thought the answer should be b. Again, why am I wrong here? > > > >------------------- > >Question 34: > > > >Which Procedure Builder component would you use to edit the properties of > >your database objects? > > > >a. Stored Program Unit Editor > >b. Program Unit Editor > >c. PL/SQL Interpreter > >d. Object navigator > > > > > >My question (to all people who took OCP PL/SQL exam recently) is: Does > >exam > >cover specific oracle tool such as "Procedure Builder" or "OEM"? It >seems > >that PL/SQL should not test any specfic tools , especially tools that are > >not widely used. Rather it should test the knowledge of PL/SQL. > > > >----------------- > > > >Thanks in advance. > > > >Guang > >________________________________________________________________________ > >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > > >-- > >Author: Guang Mei > > INET: zlmei@hotmail.com > > > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California -- Public Internet access / Mailing Lists > >-------------------------------------------------------------------- > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: ListGuru@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). > >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > >-- >Author: Rachel Carmichael >INET: carmichr@hotmail.com > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: ListGuru@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). > > >______________________________________________ >FREE Personalized Email at Mail.com >Sign up at http://www.mail.com/?sr=signup > >-- >Author: Cyril Thankappan > INET: cyril_thank@india.com > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: ListGuru@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). ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Author: Rachel Carmichael INET: carmichr@hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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). ______________________________________________ FREE Personalized Email at Mail.com Sign up at http://www.mail.com/?sr=signup -- Author: Cyril Thankappan INET: cyril_thank@india.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in