tag:blogger.com,1999:blog-8677649049588007585.post6153136574525282520..comments2023-06-18T16:15:22.432+01:00Comments on PL/SQL Challenge: Questions regarding 28 July 2010(1251)Steven Feuersteinhttp://www.blogger.com/profile/16619706770920320550noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8677649049588007585.post-80990027288429631792010-07-29T15:43:55.267+01:002010-07-29T15:43:55.267+01:00I think it may help to include use-case scenarios ...I think it may help to include use-case scenarios with questions like these.<br /><br />It can be difficult to answer these correct when you know the restrictions of RESULT_CACHE, but don't know the defined conditions that you're working with, such as the table or record's structure.<br /><br />In the answer provided, the scores were based on the table definition you used, but if it used different data types then the answers could have been different. I have the <i>joy</i> of working with LOB columns frequently, so in my experience I've had to avoid using such functionality, and I defaulted to experience with my assumptions.<br /><br />Maybe it would help clarify things if you had something like this in the assumptions before the quiz: "Unless otherwise stated, for questions without code examples, assume ideal conditions for successful compilation/execution/use." <br /><br />I'm at peace with my mistakes on this one, I just need to double check my assumptions before clicking submit. :)Anonymousnoreply@blogger.com