DOEACC Society 2009 Bachelor of Computer Application (B Level) Business System - Question Paper

M2-R3: BUSINESS SYSTEMS
NOTE:
1. There are 2 PARTS in this Module/Paper. PART 1 contains 4 ques.
and PART 2 contains 5 ques..
2. PART 1 is to be answered in the TEAR-OFF ans 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 1 – 40; PART 2 – 60)
PART ONE
(Answer all the questions)
1. every 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 Input: A="11/05/1983" select the right function to get Output: 198
A) ?SUBSTR(A,7,2)
B) ?STUFF(A,7,3)
C) ?SUBSTR(A,8,3)
D) ?SUBSTR(A,7,3)
1.2 What is output of expression: A=CEILING(5.4)?
A) 5
B) 4
C) 6
D) none of the Above
1.3 The operation carried out on an input data for examining its acceptability is termed
A) Checking
B) Moderation
C) Verification
D) Validation
1.4 Decision Table is a
A) Tabular representation of a program logic
B) Symbolic representation of a program logic
C) Graphical representation of a program logic
D) All of the above
1.5 The command to create a new database file based on 2 open database files is
A) SET RELATION
B) UPDATE
C) JOIN
D) None of the above
M2-R3 Page two of five January, 2009
1.6 The ??? shows
A) Print text to Output Screen
B) Print text directly to printer
C) Comment
D) Logical Operation
1.7 Edit Checks and Controls are built into a computer based system to
A) Ensure that transcription errors do not corrupt the outcome
B) Duplicate date does not enter into the computer system
C) Avoid transposition errors
D) All of the above
1.8 Which 1 accurate for display a record with the value 2000 in the field phone and 'false'
in the logical field paid.
A) Display for phone=2000 .AND. .NOT. paid
B) Display for phone=2000 AND paid ='false'
C) Display for phone=2000 AND. paid='false'
D) Display for phone=2000 .AND.NOT.paid
1.9 What is the Output of the subsequent program?
For I=1 to 10
?"Hello"
if(I >5)
if(I <6)
EXIT
Endif
Endif
Endfor
A) Hello will print five times
B) Hello will print six times

Earning:   Approval pending.