Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
New QUIZ Section
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00069395
Message ID:
00069423
Vues:
38
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform