tag:blogger.com,1999:blog-8677649049588007585.post813373044519813196..comments2023-06-18T16:15:22.432+01:00Comments on PL/SQL Challenge: Numbers are names, too! A mistake in the 11 November quiz (1644)Steven Feuersteinhttp://www.blogger.com/profile/16619706770920320550noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-8677649049588007585.post-844082821083778572010-11-17T09:07:38.597+00:002010-11-17T09:07:38.597+00:00Yes, Vitaliy, I think that is a legitimate point, ...Yes, Vitaliy, I think that is a legitimate point, but I am not sure how I would do it. Give everyone the same time? What time would that be? The lowest time recorded? But what if that is 10 seconds? Then that could harm someone later when I do the "too fast" adjustments.<br /><br />Better I think to just "let it go" - you got credit for a correct choice, and it is just one quiz among many...<br /><br />SFSteven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-65605575052088651372010-11-16T07:19:13.984+00:002010-11-16T07:19:13.984+00:00Now there is consistency among question, choices a...Now there is consistency among question, choices and correctness.<br /><br />But it is also not the quiz I've taken.<br />New wording obviously would cause me (and everyone) to spend<br />DIFFERENT amount of time on the quiz. For example, much faster.<br />But my quiz percentile is still reasonably bad<br />though I've originally made right decisions.<br /><br />Steven, don't you think that in case of your mistake/ambiguity<br />you should forgive not only choices but also the time<br />(taking into account only unchanged choices)?<br />Doing so you won't penalize those whom your mistake<br />lead to long time resolving of ambiguity.Vitaliy Lyanchevskiyhttps://www.blogger.com/profile/03394959689295703518noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-63263140555452196802010-11-15T15:13:57.974+00:002010-11-15T15:13:57.974+00:00Steven
I'm almost 93% sure that when I looked...Steven<br /><br />I'm almost 93% sure that when I looked at the question last Saturday it still said "could".<br /><br />I have just quickly looked at it now and it seems to be bullet-proof now :)<br /><br />Regards<br />LudoUnknownhttps://www.blogger.com/profile/03813440070210845954noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-5358659016189960342010-11-15T15:03:51.901+00:002010-11-15T15:03:51.901+00:00And I have cleaned up question and choice text so ...And I have cleaned up question and choice text so that I now believe that the choice marked incorrect CANNOT BE CORRECT. Please review and if you disagree, specify a scenario for which that would be the case.<br /><br />Thanks, SFSteven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-78306766626356005792010-11-13T22:40:25.829+00:002010-11-13T22:40:25.829+00:00Vitaliy
I see your point now. Sorry, I did not re...Vitaliy<br /><br />I see your point now. Sorry, I did not realise before that you were talking about the question. I thought you were talking about the choice wording.<br /><br />Yes, the question wording wasn't very good. I agree with you that each choice could be marked as correct as the question asks if the scenario could occur. And scenario for each choice could really occur.<br /><br />Regards<br />LudoUnknownhttps://www.blogger.com/profile/03813440070210845954noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-68705074852265295432010-11-13T20:23:01.709+00:002010-11-13T20:23:01.709+00:00domi said: "Is it yes or no?"
Quiz does...domi said: "Is it yes or no?"<br /><br />Quiz does not ask us "yes or no". It ask literally "Which of the choices describe possible scenarios that could occur?"<br />So yes, NO_DATA_FOUND could occur regardless of must name contain at least one letter or not.Vitaliy Lyanchevskiyhttps://www.blogger.com/profile/03394959689295703518noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-48831437525975798762010-11-13T17:15:52.690+00:002010-11-13T17:15:52.690+00:00Vitaliy
Original wording: "Oracle will raise...Vitaliy<br /><br />Original wording: "Oracle will raise a<br />NO_DATA_FOUND exception if all the employee last names have no more than 10 characters."<br /><br />It is true in one case (values in last_name column contain letters) but it is also incorrect in another case (valus in last_name column contain only numbers in sequential order starting with '1'). <br /><br />Is it yes or no?<br /><br />Regards<br />Ludo<br /><br />Regards<br />LudoUnknownhttps://www.blogger.com/profile/03813440070210845954noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-17215819075552243982010-11-13T06:51:31.261+00:002010-11-13T06:51:31.261+00:00> But I generally rescore when the intention of...> But I generally rescore when the intention of my quiz was contradicted by the ambiguity or mistake.<br /><br />Could someone explain me what kind of mistake and in which way can make players to respond to question "Is NO_DATA_FOUND possible?" differently from Steven's intention?Vitaliy Lyanchevskiyhttps://www.blogger.com/profile/03394959689295703518noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-63536389617628764802010-11-12T22:38:02.684+00:002010-11-12T22:38:02.684+00:00I *think* I understand your point, Vitaliy. There ...I *think* I understand your point, Vitaliy. There was a scenario under which NO_DATA_FOUND would have been raised, yes. I could have left the scoring as is. But I generally rescore when the intention of my quiz was contradicted by the ambiguity or mistake. That is the case here.Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-8992444911451587002010-11-12T22:33:40.098+00:002010-11-12T22:33:40.098+00:00Those who think that NO_DATA_FOUND couldn't oc...Those who think that NO_DATA_FOUND couldn't occur are wrong regardless of quiz wording.Vitaliy Lyanchevskiyhttps://www.blogger.com/profile/03394959689295703518noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-22370325200946079492010-11-12T22:17:27.343+00:002010-11-12T22:17:27.343+00:00I've read CHANGED quiz.
My point is: I complet...I've read CHANGED quiz.<br />My point is: I completly disagree with rescoring of NO_DATA_FOUND. In original wording it must be marked as correct without any credits.<br />Could NO_DATA_FOUND occur? - Yes, it could.Vitaliy Lyanchevskiyhttps://www.blogger.com/profile/03394959689295703518noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-11230772187326820032010-11-12T21:29:16.214+00:002010-11-12T21:29:16.214+00:00Repost.
The different choice requires rescoring:
...Repost.<br />The different choice requires rescoring:<br /><br />> Which describe possible scenarios that could occur<br /><br />Too many subjunctive mood ...<br />And choices has no adverbs which can affect possibility.<br /><br />So in general choices could look like:<br />"[If GIVEN_CONDITION then]<br /> it's possible that<br /> SOMETHING could occur"<br /><br /><br />1) If table is empty then<br /> it's possible that<br /> row will be inserted into log.<br />It's correct. It's always correct in given conditions.<br /><br /><br />2) If all length(name)<=10 then<br /> it's possible that<br /> NO_DATA_FOUND will be raised<br />It's correct. It's as a rule correct in given conditions.<br /> Because of name as a rule doesn't consist of only digit(s).<br /><br /><br />3) If any length(name) > 10 then<br /> it's possible that<br /> VALUE_ERROR will be raised<br />It's correct. It's always correct in given conditions.<br /><br /><br />4) It's possible that<br /> all rows will be shown.<br />It's correct. It's occasionally can be correct in given conditions<br /> (no conditions in this case).<br /> Because of set of all names can correspond<br /> to set of unique consecutive numbers starting from 1<br /> and no exceptions will be raised.<br /> It's nonsense in life but it's valid sample data.<br /><br /><br />So all choices should be marked as correct.<br />But (as I can see your intention) 2-nd and 4-th choices should<br />test/demonstrate misuse of integer loop (and index) with<br />associative arrays indexed by string. And following this intention<br />4-th choice should be marked as incorrect.Vitaliy Lyanchevskiyhttps://www.blogger.com/profile/03394959689295703518noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-15926454946718463192010-11-12T18:51:34.107+00:002010-11-12T18:51:34.107+00:00This just in...
John 43718 retired today. He was ...This just in...<br /><br />John 43718 retired today. He was the only employee with the last name of 43718 and Carl 43719 said he will miss working with him.<br /><br />:-)<br />MikeMikehttps://www.blogger.com/profile/04855911908563127732noreply@blogger.com