>>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

Mark, I think your answer and the Quiz answer give identical results.

>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.

A free table can have a Candidate index but not a Primary index. Although they both require unique values, the wording is different, and 'Primary' is reserved for tables belonging to a DBC. In fact if you free a table with a Primary index the index will automatically be changed to Candidate.

Barbara