ExtendedQuizQuestions

1. What does ending your query with “limit 100” do and when should you use this statement?

1. What data will this query return? {{{select * from biograph, members

where matgrp = grp and biograph.sname = members.sname and sex = 'M' and status = 0 and dcause = 0 and statdate = date order by matgrp, pid; }}}

1. What data will this query return? {{{select * from biograph, members

where biograph.matgrp = members.grp and biograph.sname = members.sname and biograph.sex = 'M' and biograph.status = 0 and biograph.dcause = 0 and biograph.statdate = date order by biograph.matgrp, biograph.pid; }}}

1. What data will this query return? {{{select *
   • from biograph
     • join members on (biograph.matgrp = members.grp and
       • biograph.sname = members.sname)
     • where biograph.sex = 'M' and
       • biograph.status = 0 and biograph.dcause = 0 and biograph.statdate = date
       order by biograph.matgrp, biograph.pid;

}}}

1. What data will this query return? {{{-- This is an illustrative query used in the Babase Quiz

-- It is fiendishly tricky so pay close attention! SELECT *

• FROM biograph
  • JOIN members ON (biograph.matgrp = members.grp and
    • biograph.sname = members.sname)
  WHERE biograph.sex = 'M' AND -- M means male (tricky 'eh?)
  • biograph.status = 0 AND biograph.dcause = 0 AND biograph.statdate = date
  ORDER BY biograph.matgrp, biograph.pid;

}}}

1. What are the pros and cons of the various queries above. Which do you prefer?