27 July 2010
Players question validity of a choice in the 26 July quiz(1249)
A half dozen players submitted the same question regarding the 26 July quiz, which asked: "Which of these blocks, when executed, display the names of tables owned by the schema to which I am currently connected?" One of the choices, which we scored as correct, offered a query against the USER_TAB_COLUMNS data dictionary view. Players objected, because the query of DISTINCT TABLE_NAME from this view would return the names not only of tables, but of views, as well. Here's one player's comment: "I did not select distinct table from from user_tab_columns option because it would also show you column names from views in the connected schema. The wording of the question could be taken either way --- it did not specify "only" tables, but it could be readily interpreted to mean that. In this case, I thought the user_tab_columns answer was a poor selection as it did not yield the precise answer the question was asking." While I can understand that this scenario would raise a question in the minds of some players, I must stand by the scoring of this choice as correct. The result set does display the names of tables owned by the schema. If the question had asked you to choose those blocks of code that display only the names of tables, it would clearly be incorrect.