Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
New QUIZ Section
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00069395
Message ID:
00069423
Views:
43
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform