DipIETE – CS (OLD SCHEME)
Code: DC07 Subject: BUSINESS SYSTEMS
Time: 3 Hours
Max. Marks: 100
NOTE: There are 9 Questions in all.
· Question 1
is compulsory and carries 20 marks. Answer to Q.1 must be written in the space
provided for it in the answer book supplied and nowhere else.
· Out of the
remaining EIGHT Questions, answer any FIVE Questions. Each question carries 16
marks.
· Any
required data not explicitly given, may be suitably assumed and stated.
Q.1 Choose the correct or the best alternative
in the following: (2
10)
a. Which of
the following is not the data type used in FoxPro?
(A) Character. (B) Real.
(C) Numeric. (D) Date.
b. Which of the following language uses the concept
of structured programming?
(A) BASIC. (B) COBOL.
(C) FORTRAN. (D) C.
c. An algorithm is _________.
(A)
a pictorial representation of
program
(B)
a set of logical step to solve the problem
(C)
set of instructions
(D)
All of the above.
d. APPEND
MEMO is used for ___________.
(A)
closing all fields (B) manipulating all fields
(C) saving
the fields (D)
configure FoxPro
e. The
ZAP command in FoxPro is used ____________.
(A)
to mark the records for deletion
(B)
to delete all the records
(C)
to undelete the selected records
(D)
to delete the selected records only
f. A
DO WHILE programming structure ends with:-
(A)
END DO (B) END
(C) STOP (D) None of the above
g. What is semantic
error?
(A)
A kind of syntax error. (B) Logical error.
(C) Physical error. (D) Kind of exception.
h. FoxBASE
is a __________.
(A)
RDBMS (B) DBMS
(C) Indexed
file system (D) FAT file
i. The
floating point number has two parts:
(A) mantissa, exponent. (B) mentiza, base.
(C) exponent,
base. (D) base, radix.
j. The
purpose of EXIT command is to __________.
(A)
get out of a condition loop
(B)
get out of FoxPro
(C)
transfer the control to a
different procedure
(D)
None of the above.
Answer any
FIVE Questions out of EIGHT Questions.
Each
question carries 16 marks.
Q.2 a. Define the following with respect to a file: (8)
(i) Gap.
(ii) Hit.
(iii) Label.
(iv) Layout.
b. Discuss about the method of access and
the situations that are best suite for the following file organizations: (8)
(i) Random.
(ii) Index sequential.
Q. 3 a. What are the tools for structured analysis?
Briefly review the tools used. (8)
b. What are the
features of top down approach in programming? What are its advantages? (8)
Q. 4 a. Explain the difference between: (8)
(i) Logical
record & Physical record.
(ii) System security and System integrity.
b. What are the functions of Database
Administrator (DBA)? (8)
Q. 5 a. Explain the difference between following
terms: (8)
(i) Schema
and Sub-schema.
(ii) Entity and Attribute.
(iii)
DDL and DML.
b.
What do you mean by financial accounting? How do you computerize
this problem? (8)
Q. 6 a. What
is the difference between SORT and INDEX command in FoxPro? Explain with an
example. (8)
b. How do
you use report in FoxPro? Explain with an example. (8)
Q.7 a. What are the components of system
documentation? Explain the role of each. (8)
b. Explain with syntax the following commands: (8)
(i) Delete.
(ii) Zap.
(iii) Pack.
(iv) Modify Command.
Q.8 a. What is MIS? What are the roles of MIS in
organizations? (8)
b. Discuss
the importance of project documentation. (8)
Q.9 a. What
are the objectives of auditing a computerized system? (8)
b. Explain various facilities
available in computerised system for Business data processing needs. (8)