[Year 12 IT Apps] The sample ITA questions -- Number 3 in Section B

[Mark KELLY]

So Access doesn't have a true Boolean datatype.... and neither does
Filemaker (one uses a number field with values of non-zero or 0).
Which RDBMS *does* have a fair dinkum native Boolean datatype?

Maybe we're being led down a digital garden path!  It might turn out that
there is no RDBMS with a true Boolean datatype, which I'm afraid would lead
to a rather stern letter to The Times.

On 4 April 2011 18:16, Timmer-Arends <timmer at melbpc.org.au> wrote:

>  Hello Maggie
>
> 2. Microslop Access does not have a Boolean datatype. It uses Yes/No as the
> closest thing to that.
>
> in fact 'yes/no' in ms access is Boolean. MS just choose to display it as
> yes/no presumably in an effort to make it simpler for the average user. You
> can also choose to display it as true/false or on/off.
>
> For example, you can use a "yes/no" field as a condition in a calculated
> field in a query.
>    moreJunk: IIf([junk],"hello","goodbye")
> where [junk] is a field declared as yes/no; ie it's boolean
>
>
> Regards
> Robert T-A
> Brighton SC
>
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
> Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers
> Association Inc
>



-- 
Mark Kelly
Manager of ICT, Reporting, IT Learning Area
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: +613 8520 9085, Fax +613 9578 9253
kel at mckinnonsc.vic.edu.au
VCE IT Lecture Notes: http://vceit.com
Moderator: IT Applications Edulist

All generalisations are false, except this one.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20110404/9bc9dc3d/attachment.html