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

C) Hello will print one time
D) Hello will print 10 times
1.10 Which 1 is not a function of Management?
A) Staffing
B) Controlling
C) Planning
D) Co-operating
M2-R3 Page three of five January, 2009
2. every statement beneath is either actual or FALSE. select the most improper one
and ENTER in the "tear-off" sheet attached to the ques. paper, subsequent
instructions therein. (1 x 10)
2.1 In a real-time system, all modifications are recorded on a online transaction file and the
master file updated for repost production when needed.
2.2 Structured programming threat to the efficiency of coding of programs.
2.3 The Top-Down approach involves working from general to specific.
2.4 Constants of a variable can be searched within obtain and SEEK commands.
2.5 Natural join joins the tables according to columns those have identical name.
2.6 SUM (Distinct) eliminates duplicate field values before determining the SUM.
2.7 The true text that you enter in Memo fields gets stored in an auxiliary table file with the
extension .ppt.
2.8 A foreign key of a table is a primary key of a different table.
2.9 Procedures are used in unstructured Programming.
2.10 Indexed data will occupy more area than Direct-access data.
3. Match words and phrases in column X with the nearest related meaning/
word(s)/phrase(s) in column Y. Enter your selection in the "tear-off" ans sheet
attached to the ques. paper, subsequent instructions therein. (1 x 10)
X Y
3.1 SPACE() A. Alternate name for database file.
3.2 ALIAS B. modifications the sequence of Instruction of execution
3.3 Cross Tab C. The clause to describe a condition on the groups of
tuples
3.4 PICTURE"@!" D. summarizing data in rows and column
3.5 Having E. Ensures that certain files are in accurate format
3.6 LIFO F. To pass privileges to a different user
3.7 ADEL G. evaluation of Stock
3.8 Grant H. can detect deadlock and livelock
3.9 Picture Check I. For insert a copy of the object from 1 application into
another
3.10 Structural Testing J. change alphabets to upper case
K. Create empty character string
L. Deletes an element from an array
M2-R3 Page four of five January, 2009
4. every statement beneath has a blank space to fit 1 of the word(s) or phrase(s) in
the list beneath. Enter your option in the "tear-off" ans sheet attached to the
ques. paper, subsequent instructions therein. (1 x 10)
A. Validation B. VED C. ranging from
D. Flow Chart E. Skip-1
F. RTOD
G. AVG
H. FIFO I. CTOD
J. Grant K. List
L. DTOC
M. Floor N. Revoke O. Picture Check
4.1 The ________ function is used to convert data expression to a character expression.
4.2 Authorization command used for Database privilege is ________.
4.3 ________ show sequence of instructions in a single program or subroutine.
4.4 ________ method is used to Stock evaluation.
4.5 ________ analysis is useful in stock Controlling of spare parts needed for maintenance.
4.6 The function that returns the degrees in an angle with the provided number of radians is
________.
4.7 Command moves the record pointer to the previous record is ________.
4.8 The ________ command is used for searching.
4.9 The operator, which is used in place of relation, as well as logical operator is called
________.
4.10 The Process of ascertaining the logical conformity of data to certain prescribed
characteristics is termed as ________.
M2-R3 Page five of five January, 2009
PART TWO
(Answer any 4 questions)
5.
a) discuss the methods of analysis for acquiring info for Long Term Planning.
b) Differentiate ranging from procedures and functions in programming language.
c) Distinguish ranging from Distributed Data Processing and Centralized Data processing?
(5+5+5)
6.
a) Distinguish ranging from index and relative file organization.
b) elaborate Visual FoxPro forms? List out features that may be incorporated into form to
facilitate easier data entry?
c) describe Inventory Control System (ICS)? provide various analysis schemes used in ICS.
(5+5+5)
7.
a) describe WHERE, ORDER BY, GROUP BY, HAVING, IN clauses in SQL?
b) elaborate the main functions of DBMS and how will you differentiate it from File
Management System?
c) Consider a subsequent database tables.
Empmaster (empcode,desgcode,empname,age,salary)
Desgmaster (desgcode,desgdescription)
i) Write a SQL Query to display details of an Employee whose empcode is 422.
ii) Write a SQL Query to update Employee Salary by 10,000 whose Age > 29.
iii) Write a SQL Query to delete an age column from Empmaster.
iv) Write a SQL Query to add empphone column into Employee table.
v) Write a SQL Query to print Average, Maximum, Minimum salary.
(5+5+5)
8.
a) What is Cross Tab Wizard? discuss the steps involved in creating query using Cross Tab
Wizard.
b) Write a procedure in FoxPro to reverse the 1st and last names of employee, which is
separated by a space. presume the field name to be NAME in a database called
EMPLOYEE.
c) describe various modes of viewing the table in Visual FoxPro? How can we operate these
modes?
(5+5+5)
9.
a) Write procedure to display 1 record at a time(column view) from database
EMPLOYEE.dbf.
Example:

Record three of 7
First name: Neha
Last name: Sharma
Address: 119 Delhi
Press Right arrow to view next record
Press Left arrow to view previous record
Press ESC to exit


b) discuss RQBE with an example?
(10+5)

Earning:   Approval pending.