Monday, 5 September 2016

NIELIT A Level July, 2012

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)
1.1 Information is gathered by a system analyst in order to
A) find out whether a computer based system is required
B) find out how the organization works.
C) find out how the current system works and what is expected from a new computer based
D) find out who will use the system
1.2 A physical DFD specifies
A) what processes will be used
B) who generates data and who processes it
C) what each portion in an organization does
D) what data will be generated

1.3 An update operation in an object instance
A) updates the class
B) has no side-effects
C) deletes an instance
D) alters values of attribute(s) of an object instance
1.4 Normalization is a process of restoring a relation to
A) minimize duplication of data in a database
B) maximize duplication of data to ensure reliability
C) make it of uniform size
D) allow addition of data
1.5 A cost-benefit analysis is performed to assess
A) economic feasibility
B) operational feasibility
C) technical feasibility
D) All of the above

1.6 Backup procedure helps in restoring
A) data files whenever there is a system crash
B) both Application and System Software whenever there is a Disk corruption/failure
C) Both A) and B)
C) None of the above
1.7 ABC analysis, in Inventory Control is performed by comparing
A) items used against items unused/infrequently used
B) value of items consumed with their quantities
C) value of items held in stock with their quantity
D) value of items held in stock with the number of items
1.8 A major principle of modularization is
A) The cohesion of each module should be low and coupling between modules should be high
B) The number of modules should be as low as possible
C) The number of modules should be as high as possible
D) Each module should have a high degree of cohesion
1.9 A Distributed Data Processing System
A) attempts to capture advantages of both centralized and decentralized processing
B) does not allow greater flexibility
C) provides slow access to data
D) none of the above
1.10 A DBMS is
A) another name for database systems
B) independent of a database
C) dependent on application programs
D) a set of procedures which manage a database

2. Each statement below is either TRUE or FALSE. Choose the most appropriate one and ENTER in the “tear-off” sheet attached to the question paper, following instructions therein. (1x10)

2.1 A decision table is a pictorial representation of data flow.
2.2 Entities may have similar attributes.
2.3 Decision support systems support structured decisions.
2.4 Unit test is done to test a program comprising of few modules.
2.5 Data validation is not necessary for an online data input.
2.6 The System Review is carried out periodically even after the system is successfully
2.7 By auditing around the computer we mean programs are written to check the functioning of
the computer hardware.
2.8 A firewall is used in a system to a wide area network to prevent spread of fire in the network.
2.9 Data dictionaries can be used for detecting errors.
2.10 A polymorphic operation uses different methods to perform on the same class.

3. Match words and phrases in column X with the closest related meaning/word(s)/phrase(s) in column Y. Enter your selection in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)
                                     X                                                         Y
3.1 Gantt Chart                                                         A. Reasonableness of input
3.2 Benchmarking                                                    B. Selection of hardware and software
3.3 Pseudocode precedes                                         C. Structured English
3.4 if-then-else-endif                                               D. Analysis
3.5 Data Flow                                                          E. Model
3.6 Prototype                                                           F. Arrow
3.7 Interviews                                                         G. Output Design
3.8 Range Check                                                     H. Planning Tool
3.9 Pull-down-menu                                                I. Input design
3.10 Display Layout Chart                                      J. Decision Table
                                                                                K. Structured-Unstructured
                                                                                L. Selection by User
                                                                                M. Coding

4. Each statement below has a blank space to fit one of the word(s) or phrase(s) in the list below. Enter your choice in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

A. Data ConsistencyChecks       B. Documentation                                C. System Specifications
D. Open System                         E. Audit trail                                         F. Budget
G. User Interface                       H. Coding                                               I. Finance
J. Module                                   K. Testing                                             L. External
M. Authentication

4.1 The three basic sub-systems (business functions) of any industrial organization are
Marketing, Manufacturing and ________.
4.2 ________ is the hardware/software boundary that permits communication between people
and computers.
4.3 ________ is the process of making sure that the programs perform the intended
4.4 Manager performing strategic planning requires ________ information.
4.5 ________ is a management decision.
4.6 ________ testing must precede integration testing and system testing.
4.7 A permanent record of any update that is made by a program is kept using ________.
4.8 ________ are essential to assure that the developer and the customer have the same
perception of the system.
4.9 In most computer systems, access control is exercised by means of some form of
4.10 If a Data Dictionary is not included in the System Analysis and Design of a software project,
then ________ cannot be carried out well.

(Answer any FOUR questions)
5. Write brief notes on any three of the following:
a) Archival Data
b) Primary Key
c) Black-Box testing
d) Data Mining
a) What is the difference between MIS and DSS?
b) What are main principles in designing forms for data entry?
c) What is the difference between a conceptual model and a logical model of the database?
d) What do you understand by the term data integrity?
a) What is Context diagram? What is the difference between a logical DFD and a physical
b) Who is DBA? Explain the role of DBA in an organization.
c) What is the difference between a pilot test and a parallel test?
a) Define an object. Why is object-oriented modeling used in practice?
b) Distinguish between technical, operational and economic feasibility.
a) An organization has several departments. Each department employs several employees. A
job can be done by many employees or by just one employee. Structures of EMPLOYEE,
DEPARTMENT and JOB tables are as follows:
EMPLOYEE (Emp_code, Emp_name, Dept_code. Job_code, Grade)
DEPARTMENT (Dept_code, Dept_name, Location)
JOB (Job_code, Duration, Resources)
Draw an E-R diagram for the organization
b) The policy followed by an organization to process customer orders is given by the following
i) If the customer order is less than or equal to that in stock and his credit is OK, supply
his requirement.
ii) If the customer credit is not OK, do not supply. Send him intimation.
iii) If the customer credit is OK but items in stock are less than his order, supply what is
in stock. Enter balance to be sent in back-order table.
Construct a decision table for the above policy.