Quiznetik

Business Information Systems | Set 2

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...........

Correct : B. macro

92. In MIS, SDLC stands for............

Correct : D. system development life cycle