tag:blogger.com,1999:blog-8677649049588007585.post3517516245686595283..comments2015-06-17T13:17:01.965+01:00Comments on PL/SQL Challenge: Daily quiz becoming a trivia contest?Steven Feuersteinhttp://www.blogger.com/profile/16619706770920320550noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-8677649049588007585.post-47617815744148153762010-07-29T11:59:21.944+01:002010-07-29T11:59:21.944+01:00I cannot make an assumption that all code compiles...I cannot make an assumption that all code compiles without error, for precisely the reason that Jeff points out. I need to make sure that through my careful editing and review by others that the ONLY reason a block of code will not compile is because I deliberately inserted the error for reasons relevant to the quiz at hand.<br /><br />SFSteven Feuersteinhttp://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-49840811933894307332010-07-29T05:45:04.985+01:002010-07-29T05:45:04.985+01:00David said: &quot;...And please please avoid quest...David said: &quot;...And please please avoid questions/answers where it all depends on very stupid syntax errors. I mean for example that a certain answer is not correct because the semicolon at the end of the line or such.&quot;<br /><br />This could be catered for by stating in the question &quot;assume that all the code in the answers compile without error&quot;. Steven has added a statement like this to a few questions, which is a big help.<br /><br />Otherwise, in the absence of such a disclaimer, if I see a syntax error (no matter how stupid) I&#39;d mark the answer as wrong.<br /><br />Unfortunately, this disclaimer is not always feasible - e.g. in a question that asks &quot;which of the following will compile and run without error&quot;.<br /><br />Regarding the overall question about this being a &quot;trivia contest&quot;, I&#39;d have to say that this can be quite subjective. What is trivial for you may be an important point for me; we all work on different systems which have been built by different people with different skill levels, different backgrounds, using different parts of the language.<br /><br />Like my dad always used to say: &quot;any question is easy - if you know the answer&quot; :)<br /><br />Jeffjeffkemponoracle.comhttp://jeffkemponoracle.com/noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-41656050456264075902010-07-27T19:02:08.872+01:002010-07-27T19:02:08.872+01:00I agree with the op that the challenge sometimes r...I agree with the op that the challenge sometimes resembles a &quot;trivia contest&quot;. But it is still for the most part both a fun and informative exercise. Let&#39;s hope we don&#39;t have a &quot;find the missing semi-colon&quot; question any time soon.<br />And I too don&#39;t envy you for having to come up with a question every day. <br />Keep up the good work!Nicholashttp://www.blogger.com/profile/10992934064012209789noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-54497150362475430952010-07-27T09:10:18.454+01:002010-07-27T09:10:18.454+01:00I think that it&#39;s hard to have a common agreem...I think that it&#39;s hard to have a common agreement on what is best practice. Everyone has different experiences here. It will end up in endless discussions on very specific small details.<br /><br />I think it would be enough if you explain the pros/cons or best practices when the answers of the questions are published. Just a small comment why this or that option is not a good choice for real life programming, or why another option is recommended.<br /><br />And there will be always discussions on how to interpret the words you have chosen in the question. So keep the questions simple and without too much details. And please please avoid questions/answers where it all depends on very stupid syntax errors. I mean for example that a certain answer is not correct because the semicolon at the end of the line or such.<br /><br />Thanks for the great site. It&#39;s great to learn something new on your site every day.<br /><br />David.Davidhttp://www.blogger.com/profile/14511056501986373205noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-41880745715641312982010-07-23T15:28:51.172+01:002010-07-23T15:28:51.172+01:00Keeping the questions to &quot;best-practice&quot;...Keeping the questions to &quot;best-practice&quot; examples only would be bad in my opinion. Part of being a good programmer is being able to understand, maintain, and fix cases of &quot;non-best-practice&quot; code. <br /><br />It is also important to consider that what may have been best-practice in Oracle 8i is likely not going to be best-practice in Oracle 10g or 11g. As the technology evolves, so does the &quot;standards&quot; of what best-practice is. Regardless, it&#39;s code that we will eventually inherit, and possibly rewrite to our modern standards.<br /><br />Overall I feel the PL/SQL Challenge questions have been very good and quite educational. I&#39;ve seen questions on Oracle exams that were more ambiguous, confusing, and frustrating to answer. :)<br /><br />Keep up the great work!<br />- RichardRichard M.http://www.blogger.com/profile/14970710559271921484noreply@blogger.com