1. A computer security protocol for logging in would be an example of the ________________
component of an information system.
Correct : D. procedure e. people
2. Customer numbers and their names would be an example of the __________________
component of an order management information system.
Correct : C. data
3. Non routine cognitive skills include:
Correct : D. all of the above.
4. The quality of your ____________is a large part of the quality of your information system.
Correct : B. thinking
5. Which of the following is not a characteristic of good information?
Correct : A. interchangeability
6. If you are a ___________________ recipient of sensitive information, such as might be
overheard or contained in a misdirected email, this would not be illegal, but might be unethical to use it.
Correct : B. passive
7. A human order taking can be bypassed when using a(n) _____________ .
Correct : C. transaction processing system
8. Data mining cannot be done if
Correct : A. operational data has not been archived
9. Batch processing is preferred over on-line transaction processing when
i) Processing efficiency is important
ii) The volume of data to be processed is large
iii) Only periodic processing is needed
iv) A large number of queries are to be processed
Correct : D. i , ii ,iii
10. On-line transaction processing is used when
i) it is required to answer random queries
ii) it is required to ensure correct processing
iii) all files are available on-line
iv) all files are stored using hard disk
Correct : B. i, iii
11. Which is not a domain of Artificial Intelligence?
Correct : D. none of the above
12. Which one of the following is used for evaluating credit risks?
Correct : B. neural network
13. . Which computer based model is developed after human brain?
Correct : B. neural network
14. Knowledge based system supports____________ .
Correct : D. all of the above
15. Which of the system uses Multidimensional data analysis?
Correct : A. dss
16. Cybernetic system is the one which is
Correct : D. all of the above.
17. Globalization and the increasing internet users around the world, give IT budgets
Correct : A. high priority
18. MRP II is accurately described as
Correct : C. mrp augmented by other resource variables
19. Enterprise Resource Planning (ERP) is
Correct : C. an advanced mrp ii system that ties-in customers and suppliers
20. The extension of MRP which extends to resources such as labour hours and machine hours, as
well as to order entry, purchasing, and direct interface with customers and suppliers is
Correct : B. enterprise resource planning
21. Distribution Resource Planning (DRP) is
Correct : B. a time-phased stock replenishment plan for all levels of a distribution network
22. In what way are Distribution Resource Planning (DRP) and Material Requirements Planning
(MRP) similar?
Correct : A. both employ similar logic and procedures.
23. Which is true in Enterprise resource planning (ERP)
Correct : D. automates and integrates the majority of business processes
24. Enterprise resource planning (ERP)
Correct : D. all of the above are true of erp.
25. Which of the following is false concerning enterprise resource planning (ERP)?
Correct : C. it is inexpensive to implement.
26. All of the following are advantages of enterprise resource planning (ERP) except it
Correct : D. requires major changes in the company and its processes to implement
27. ---------- is a collection of logically related records and file
Correct : C. database
28. Which of the following is / are file organisation type?
Correct : D. all the above
29. …………… is an interface between users and the various databases
Correct : C. dbms
30. Overall design of database is called………..
Correct : C. schema
31. Information currently stored in the database is called……….
Correct : A. instance
32. Lowest level of schema in a database is
Correct : A. physical schema
33. Highest level of schema in a database is
Correct : B. logical schema
34. Analysing data from different sources and perspectives and summarising it into useful
information is
Correct : D. data banking
35. Which of the following is not included in three level of data abstraction
Correct : D. data link
36. A system which record and report business transactions, flow of funds and generate financial
statements is.....
Correct : C. accounting information system
37. The automatic transfer and positioning of work by machine without significant human
intervention or operation is..........
Correct : B. automation
38. An information system within a business organisations that support the traditional functions
such as marketing, finance or production is.............
Correct : B. bis
39. Restructuring and transforming a business process by a fundamental rethink and redesign to
achieve dramatic improvement in cost, quality etc...........
Correct : B. business process reengineering
40. A system of creating, delivering and receiving electronic message is...........
Correct : B. communication system
41. A set of tools to help application developers to complete software development quickly and
accurately is
Correct : C. case
42. CIM stands for
Correct : B. computer integrated manufacturing
43. A Business Information System planning technique that identify key business goal and
strategies is
Correct : B. csf
44. ............ means “data about data”
Correct : C. meta data
45. ......... gives information about information
Correct : B. data dictionary
46. Controls that are used to prevent incorrect data from being entered into database
Correct : B. data validation
47. A system that stores, retrieves, manages or otherwise manipulates a massive amounts of data
from organisation’s database and external sources.
Correct : D. data warehousing
48. An MIS professional responsible for planning ,designing and maintaining database is
Correct : C. database administrator
49. The activity of keeping a database up to date by adding, changing, or deleting data
Correct : D. data maintenance
50. DBMS is a collection of.....,.............
Correct : C. software only
51. In.............. models data are conceived in the form of table
Correct : C. relational database
52. An information system that directly support both the operational and managerial applications of
end users
Correct : A. eucs
53. EUCS stands for.............
Correct : B. end user computing system
54. An information system that provides strategic information tailored to the needs of top
management.
Correct : A. executive information system
55. An executive information system with additional capabilities including data analysis, decision
support, electronic mail, and personal productivity tools
Correct : A. executive support system
56. A computer based information system that uses its knowledge about specific complex
application area to act as an expert consultant to users.
Correct : B. expert system
57. A set of programmes that uses data from master production schedule, inventory files and bill of
materials to help and manage production and inventory
Correct : A. material requirements planning
58. The software that extends a production information system to other functional areas like
finance, marketing, HR etc.
Correct : B. manufacturing resource planning
59. An information system that process data arising from occurrence of business transactions
Correct : B. transaction processing system
60. A database that stores and manages objects
Correct : A. oodb
61. In Ms Excel, Which function calculates the largest value in a set of numbers?
Correct : D. maximum
62. In Excel, What do you use to create a chart?
Correct : D. chart wizard
63. What displays the content of the active cell?
Correct : C. formula bar
64. By default, your documents print in------------mode.
Correct : B. portrait
65. A table in a relational database is known as
Correct : D. relation
66. Which of the following is not an example of word processor
Correct : D. ms office
67. ............ is the process of manipulation text using computer
Correct : C. word processing
68. ............. is a facility in MS Word to create multiple letters and mails
Correct : B. mail merge
69. ............... is simply speaking a spread sheet application.
Correct : D. all of these
70. Spread sheet type document is also known as..........
Correct : C. work book
71. In Excel each work book will consists of............. work sheets by default
Correct : D. 3
72. Which of the following is/are components of DBMS
Correct : D. all of these
73. In DBMS ... is a field or combination of fields that uniquely identify each record in a table.
Correct : B. primary key
74. A primary key which is appeared in related tables is known as.............of related or secondary
table
Correct : C. foreign key
75. In DBMS ... ensures the validity of the relationship between two table remain intact.
Correct : A. referential integrity
76. MS Access is a ............ application
Correct : D. dbms
77. Which of the following is an object in MS Access
Correct : D. any of the above
78. .............. is a series of commands that is recorded so it can be played back, or executed later.
Correct : C. macro
79. A ............. is a predetermined formula in Excel.
Correct : B. function
80. Which of the following is “What-if-analysis in excel?
Correct : C. both of these
81. Ms Excel is an application to prepare............
Correct : B. spreadsheets
82. MS Power point is an application to prepare...............
Correct : D. slides
83. Ms Offdice is a................
Correct : D. an application suit
84. Which of the following is a financial function in excel?
Correct : D. npv
85. Which of the following is a statistical function in excel?
Correct : D. any of the above
86. In Excel, More than one data can be entered in a single cell by using............. facility
Correct : D. scenario
87. Questions can be raised in Ms Access by using............
Correct : A. queries
88. Data storage in Ms Access is as.............
Correct : A. table
89. In MS Access rows are technically called..........
Correct : C. tuples
90. In MS Access columns are technically called..........
Correct : B. attributes
91. In Ms Access, actions can be automated by using...........