F.4 Computer Studies Final Examination 2000 Answers
Section A   Multiple Choice
1. D   2. D   3. D   4. A   5. C
6. E   7. D   8. C   9. E   10.E
11.D   12.D   13.D  

Section B
14. a) -31
    b) 31
    c)     Integer      Sign-magnitude     Two's complement
             28           011100               011100
            -19           110011               101101

15.  Program answer is found at the last page of the Question Paper

16.      Line Number              Corrected Statement
            20                Year: array[1..12] of string;
           150                until I>=1900;
           170                J:=I-I div 12 * 12 + 1;
           180                writeln('The animal fpr the year ',I,' is ',Year[J]);
           220                until Choice<>'Y';
 
17. Program answer is found at the last page of the Question Paper

18. a) yes, Windows NT/2000
    b) Bar code reader
    c) i) PASCAL - third choice, a programming language, staff requires knowledge of this language,
                   no support for networking, not suitable for managing large volume 
                   of data.
       ii) Spreadsheet - second choice, product data can easily be transcripted, easy to use.
                         Security of data is weak. No query and no report provided, cannot 
                         taylor make for special input/output process.
       iii) database -  first choice, form, query and report are commonly used in database. 
                        Sorting of particular field and searching in large volume of data
                        are powerful. A taylor-made program can be written by professional for 
                        daily routine file management.

19. i) 3
    ii) Customer 3 has paid most.
        This customer has paid $9.5+7.8+26 i.e. $43.3
    iii) Local Area Network (LAN) with STAR & BUS connection

20.      Field name               Character/Numeric      No. of characters  decimal
         prod_no                      C                       6
         prod_name                    C                       30
         unit_price                   N                       5             2
         quantity                     N                       5  
         transc_no                    N                       6
         staff_no                     N                       2