DECLARE TYPE numbers_t IS TABLE OF NUMBER; l_table numbers_t := numbers_t ();Several people have written to me about this (actually, on a different blog post - I will copy them below for clarity) as follow: "I completely mis-read today's quiz for October 12th, and looking at the average score, I am assuming everyone else did too. I thought all the choices referred to an empty table/array, even though in retrospect you clearly say otherwise. Live and learn, I guess." "Yes, the quiz would be much more clear if a comment like /* some operations on the l_table here */ will be present in the block." And two players put together a block of code to demonstrate that the way I scored the answers was incorrect for the empty nested table shown in the question. I thought it was rather clear that since (a) I do not include the executable section and (b) I say "always true, regardless of the contents of the nested table" (italics added), I am asking you which statement will be true regardless of what you do with the nested table in the executable section. Not clear enough, I suppose. I am not going to change the score (uh oh, perhaps others will stop playing the Challenge? Hmmm. It is 5:45 AM. Perhaps I am just irritable). I will, however, change the text of the question so that it is more clear in the future (I say this because I plan in the future for you to be able to take quizzes again, to practice and further sharpen your knowledge!). Regards, SF
13 October 2010
Questions regarding 12 October quiz and contents of nested table (1505)
The 12 October quiz asked the following: Assuming that l_table is declared as you see below, which of these Boolean expressions are always true, regardless of the contents of the nested table?