QN1. Requirement specification is carried out
a) After requirements are determined
b) Before requirements are determined
c) Simultaneously with requirements determination
d) Independent of requirements determination
Answer
Answer: a) After requirements are determined
QN2. The role of a system analyst drawing up a requirements specification is similar to
a) Architect designing a building
b) A structural engineer designing a building
c) A contractor constructing a building
d) The workers who construct a building
Answer
Answer: a) Architect designing a building
QN3. It is necessary to consult the following while drawing up requirement specification
a) Only top managers
b) Only top and middle management
c) Only top, middle and operational managers
d) Top, middle and operational managers and also all who will use the system
Answer
Answer: d) Top, middle and operational managers and also all who will use the system
QN4. In order to understand the working of an organization for which a computer based system is being designed, an analyst must
a) Look at only current work and document flow in the organization
b) Discuss with top level and middle level management only
c) Interview top, middle, line managers and also clerks who will enter data and use the system
d) Only clerical and middle level staff who have long experience in the organization and will be users of the system
Answer
Answer: c) Interview top, middle, line managers and also clerks who will enter data and use the system
QN5. A feasibility study is carried out
a) After final requirements specifications are drawn up
b) During the period when requirements specifications are drawn up
c) Before the final requirements specifications are drawn up
d) At any time
Answer
Answer: c) Before the final requirements specifications are drawn up
QN6. The main objective of feasibility study is
a) to assess whether it is possible to meet the requirements specifications
b) to assess if it is possible to meet the requirements specified subject to constraints of budget, human resource and hardware
c) to assist the management in implementing the desired system
d) to remove bottlenecks in implementing the desired system
Answer
Answer: b) to assess if it is possible to meet the requirements specified subject to constraints of budget, human resource and hardware
QN7. Hardware study is required
a) To find out cost of computer system needed
b) To determine the type of computer system and software tools needed to meet the final system specification
c) To make sure that the system does not become obsolete
d) To find how to implement the system
Answer
Answer: b) To determine the type of computer system and software tools needed to meet the final system specification
QN8. Feasibility study is carried out by
a) Managers of the organization
b) System analyst in consultation with managers of the organization
c) Users of the proposed system
d) Systems designers in consultation with the prospective users of the system
Answer
Answer: b) System analyst in consultation with managers of the organization
QN9. Initial requirements specification is
a) Not changed till the end of the project
b) Continuously changed during project implementation
c) Only a rough indication of the requirement
d) Changed and finalized after feasibility study
Answer
Answer: c) Only a rough indication of the requirement
QN10. The primary objective of system design is to
a) Design the programs, databases and test plan
b) Design only user interfaces
c) Implement the system
d) Find out how the system will perform
Answer
Answer: a) Design the programs, databases and test plan
QN11. System test plan is specified
a) When the final specifications are drawn up
b) During feasibility study
c) During the requirements specifications stage
d) During system study stage
Answer
Answer: a) When the final specifications are drawn up
QN12. System design is carried out
a) As soon as system requirements are determined
b) Whenever a system analyst feels it is urgent
c) After final system specifications are approved by the organization
d) Whenever the user management feels it should be done
Answer
Answer: c) After final system specifications are approved by the organization
QN13. The primary objective of system implementation is
i) To build a system prototype
ii) To train users to operate the system
iii) To implement designed system using computers
iv) Write programs, create databases and test with live data
a) i, iii
b) i, ii, iii
c) ii, iii
d) ii, iv
Answer
Answer: d) ii, iv
QN14. The main objective of system evaluation is
a) To see whether the system met specification
b) To improve the system based on operational experience for a period
c) To remove bugs in the programs
d) To asses the efficiency of the system
Answer
Answer: b) To improve the system based on operational experience for a period
QN15. A data dictionary has consolidated list of data contained in
(i) Data flows
(ii) Data stores
(iii) Data outputs
(iv) processes
a) (i) and (iii)
b) (i) and (ii)
c) (ii) and (iv)
d) (i) and (iv)
Answer
Answer: b) (i) and (ii)
QN16. System analysts have to interact with
i) Managers of organizations
ii) Users in the organization
iii) Programming team
iv) Data entry operator
a) iii and iv
b) i, ii and iii
c) ii, iii and iv
d) ii and iii
Answer
Answer: b) i, ii and iii
QN17. Systems analyst should use software tools in their work as
a) All analysts use them
b) They assist in systematic design of systems
c) They are inexpensive
d) They are easily available
Answer
Answer: b) They assist in systematic design of systems
QN18. During feasibility analysis it is necessary to examine several alternative solutions because
(i) A comparison of alternatives will lead to a cost-effective solution
(ii) A pre-conceived single solution may turn out to be unimplementable
(iii) It is always good to examine alternatives
(iv) Management normally looks at alternatives
a) i and iii
b) i and iv
c) i and ii
d) ii and iv
Answer
Answer: c) i and ii
QN19. The primary responsibility of a systems analyst is to
a) Specify an information system which meets the requirements of an organization
b) Write programs to meet specifications
c) Maintain the system
d) Meet managers of the organization regularly
Answer
Answer: a) Specify an information system which meets the requirements of an organization
QN20. The responsibilities of a system analyst include
i) Defining and prioritizing information requirement of an organization
ii) Gathering data, facts and opinions of users in an organization
iii) Drawing up specifications of the system for an organization
iv) Designing and evaluating the system
a) i and ii
b) i, ii and iv
c) i, ii, iii and iv
d) i, ii and iii
Answer
Answer: d) i, ii and iii
QN21. The intangible benefits in the following list are
(i) Savings due to reducing investment
(ii) Savings due to sending bills faster and consequent early collection
(iii) Providing better service to the customers
(iv) Improving quality of company’s products
a) i and ii
b) ii and iii
c) iii and iv
d) i and iii
Answer
Answer: c) iii and iv
QN22. In a DFD external entities are represented by a
a) Rectangle
b) Ellipse
c) Diamond shaped box
d) Circle
Answer
Answer: a) Rectangle
QN23. A data flow can
a) Only emanate from an external entity
b) Only terminate in an external entity
c) May emanate and terminate in an external entity
d) May either emanate or terminate in an external entity but not both
Answer
Answer: c) May emanate and terminate in an external entity
QN24. The most important attribute of a systems analyst is
a) Excellent programming skills
b) Very good hardware designing skills
c) Very good technical management skills
d) Very good writing skills
Answer
Answer: c) Very good technical management skills
QN25. Data inputs which required coding are
a) Fields which specify prices
b) Key fields
c) Name fields such as product name
d) Fields which are of variable length
Answer
Answer: b) Key fields
QN26. An entity is
a) A collection of items in an application
b) A distinct real world item in an application
c) An inanimate object in an application
d) A data structure
Answer
Answer: b) A distinct real world item in an application
QN27. A relationship is
a) An item in an application
b) A meaningful dependency between entities
c) A collection of related entities
d) Related data
Answer
Answer: b) A meaningful dependency between entities
QN28. A cost-benefit analysis is performed to assess
a) Economic feasibility
b) Operational feasibility
c) Technical feasibility
d) All of the above
Answer
Answer: a) Economic feasibility
QN29. Among the attributes of a systems analyst the following are most important
i) Knowledge of computer systems and currently available hardware
ii) Good interpersonal relations
iii) Broad knowledge about various organizations
iv) Very good accountancy knowledge
a) i, iii and iv
b) i and iii
c) i, ii and iv
d) i, ii and iii
Answer
Answer: d) i, ii and iii
QN30. A rectangle in a DFD represents
a) A process
b) A data store
c) An external entity
d) An input unit
Answer
Answer: c) An external entity
QN31. The entity set is a
a) Set of entities
b) Collection of different entities
c) Collection of related entities
d) Collection of similar entities
Answer
Answer: d) Collection of similar entities
QN32. Attributes are
(i) Properties of relationship
(ii) Attributed to entities
(iii) Properties of members of an entity set
a) i
b) i and ii
c) i and iii
d) iii
Answer
Answer: c) i and iii
QN33. Rows of a relation are called
a) Tuples
b) A relation row
c) A data structure
d) An entity
Answer
Answer: a) Tuples
QN34. If an entity appears in N relationships then it is
a) A 1:1 relationship
b) A 1: N relationship
c) A N: 1 relationship
d) A N: M relationship
Answer
Answer: b) A 1: N relationship
QN35. Normalization is a process of restructuring 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
Answer
Answer: a) Minimize duplication of data in a database
QN36. Normalization of database is essential to
(i) Avoid accidental deletion of required data when some data is deleted
(ii) Eliminate inconsistencies when a data item is modified in the database
(iii) Allows storage of data in a computer’s disk
(iv) Use a database management system
a) i and iii
b) i and ii
c) ii and iii
d) ii and iv
Answer
Answer: b) i and ii
QN37. A relation is said to be in 1NF if
a) There is no duplication of data
b) There are no composite attributes in the relation
c) There are only a few composite attributes
d) All attributes are of uniform type
Answer
Answer: b) There are no composite attributes in the relation
QN38. By redundancy in a file based system we mean that
a) Unnecessary data is stored
b) Same data is duplicated in many files
c) Data is unavailable
d) Files have redundant data
Answer
Answer: b) Same data is duplicated in many files
QN39. Data integrity in a file based system may be lost because
a) The same variable may have different values in different files
b) Files are duplicated
c) Unnecessary data is stored in files
d) Redundant data is stored in files
Answer
Answer: a) The same variable may have different values in different files
QN40. Given the following relation— vendor order (vendor no, order no, vendor name, qty supplied, price/unit) it is not in 2 NF because
a) It is not in 1 NF
b) It has a composite key
c) Non-key attribute vendor name is dependent on vendor no. which is one part of the composite key
d) Qty supplied and price/unit are dependent
Answer
Answer: c) Non-key attribute vendor name is dependent on vendor no. which is one part of the composite key
