>Check out the new QUIZ section now available in the KnowledgeBase (click on the red dice). There are (as of this writing) 43 questions, but we'd like to see 100.
It's a nice feature, but I think that a bit more proof reading might be helpful. For example question 7 had no correct answer:
SELECT invoiceno, sum(costs) as totcost from invoice into cursor MyCosts group by invoiceno
SELECT top 10 invoiceno, cnt(costs) as totcost from invoice into cursor MyCosts group by invoiceno, order by totcost
SELECT invoiceno, cnt(costs) as totcost from invoice into cursor MyCosts group by invoiceno
SELECT top 10 percent invoiceno, sum(costs) as totcost from invoice into cursor MyCosts group by invoiceno, order by totcost
SELECT invoiceno, cnt(costs) as totcost from invoice into cursor MyCosts
The quiz said that choice C was correct. But it should be something like:
SELECT invoiceno, cnt(*) as InvCount from invoice into cursor MyCosts group by invoiceno
Also, #10 said regarding free tables, that only: "Can have a unique ID field and a candidate index on that field" was correct, but it's also easy to implement a free table such that it "Can have a primary key and primary index". That's an implementation issue, not a capability issue.