DOEACC Society 2007 Advanced Level Course In Computer Science A2-R3: BUSINESS SYSTEMS - Question Paper

A2-R3: BUSINESS SYSTEMS

NOTE:
1. There are 2 PARTS in this Module/paper. PART 1 contains 4 ques. and PART 2 contains 4 ques..

2. PART 1 is to be answered in the TEAR-OFFANSWER SHEET only, attached to the ques. paper, as per the instructions contained therein. PART 1 is NOT to be answered in the ans book.

3. Maximum time allotted for PART 1 is 1 HOUR. ans book for PART 2 will be supplied at the table when the ans sheet for PART 1 is returned. However, candidates who complete PART 1 earlier than 1 hour, can collect the ans book for PART 2 immediately after handing over the ans sheet for PART ONE.
TOTAL TIME: three HOURS TOTAL MARKS: 100
(PART ONE-40; PART 2 – 60)

PART ONE
(Answer all the questions)

1. Each ques. beneath provide a multiple option of answers. select the most improper 1 and enter in the “tear-off” ans sheet attached to the ques. paper, subsequent instructions therein. (1 x 10)

1.1 Using Visual FoxPro, the number of table that we can use simultaneously is:
A) 225
B) 205
C) 255
D) 252

1.2 The Windows element in Visual FoxPro are:
A) Application Window
B) Project Manager Window
C) Command Window
D) All of the above

1.3 One of the subsequent is not actual for the Status Bar of a Visual FoxPro Window
A) This bar is placed at the bottom of the application window
B) It provides the details of the currently open window
C) An active window will make the colour of the status bar to change to dark
D) Information like OVR, NUM, Caps etc. is displayed on the Status Bar

1.4 Which 1 of the subsequent is not actual for the Memo data kind in Visual FoxPro?
A) Memo fields act as variable-length character fields.
B) The limit to the length of the Memo field is 254 characters
C) Memo data kind can hold scanned images and digitized sound
D) You can manipulate this data kind by using any of the functions that manipulate Character fields










1.5 In an Accountant’s system, collection of all money on temporary and permanent accounts is maintained in the
A) Cash journal
B) General ledger
C) Accounts payable component
D) Double entry balance system

1.6 Which 1 of the subsequent is a valid SQL command:
A) SELECT Emplist.Iname, Emplist.fname, Wages.date, Wages,wage;
FROM Wages, Emplist;
WHERE Wages.empno = Emplist.empno
B) SELECT Emplist.Iname, Emplist.fname, Wages.date, Wages.wage
FROM Wages, Emplist
WHERE Wages.empno = Emplist.empno
C) SELECT Emplist.Iname, Emplist.fname, Wages.date, Wages.wage,
FROM Wages, Emplist,
WHERE Wages.empno = Emplist.empno
D) SELECT Emplist.Iname Emplist.fname Wages.date Wages.wage,
FROM Wages Emplist;
WHERE Wages.empno = Emplist.empno

1.7 In a program, if you desire to exit unconditionally out of SCAN – ENDSCAN loop, you will use the subsequent command:

Earning:   Approval pending.