Management Information System

Unit – 1

1.Relational calculus is a
(1) Procedural language. (2) None- Procedural language.(3) Data definition language.

2.The view of total database content is
(1) Conceptual view (2) Internal view. (3) External view.

3.DML is provided for
(1) Description of logical structure of database. (2) Addition of new structure in the database system. (3) Manipulation &processing of database.

4. ODBC stands for
(1) Object Database Connectivity. (2) Oral Database Connectivity (3) Open Database Connectivity.

5. Architecture of the database can be viewed as
(1) Two levels. (2) Four levels. (3) Three levels.

6. The database schema is written in
(1) HLL (2) DML (3) DDL

7. In the architecture of a database system external level is the
(1) Logical level. (2) Conceptual level (3) View level.

8. In a Hierarchical level model records are organized as
(1) List (2) Links (3) Tree

9. The language used in application programs to request data from the DBMS is referred to as the
(1) DML (2) DDL (3) VDL

10. The DBMS language component which can be embedded in a program is
(1) The data definition language (DDL) (2) The data manipulation language(DML) (3) The database administrator

11. Which one of the following statement is false?
(1) The data dictionary is normally maintained by the database administrator. (2) Data elements in the database can be modified by changing the data dictionary. (3) The data dictionary contains the name and description of each data element.

12. An advantage of the database management approach is
(1) Data is dependent on programs. (2) Data redundancy increase. (3) Data is integrated and can be accessed by multiple programs.

13. A DBMS query language is designed to
(1) Support end users who use English-like commands. (2)Support in the development of complex applications software. (3) All of the above.

14. Key to represent relationship between tables is called
(1) Primary key (2) Secondary Key (3) Foreign Key

15. The full form of DDL
(1) Dynamic Data Language (2) Detailed Data Language (3)Data Definition Language

16. Which database level is closest to the users?
(1) External (2) Internal (3) Physical

17. Hierarchical model is also called
(1) Tree structure (2) Plex Stucture (3) Normalize Structure

18. Information system that monitor the elementary activities and transactions of the organizations are
(1) Management-level system (2) Operational-level system (3) Knowledge-level system

19. Projections and responses to queries are information output characteristics associated with a (n)
(1) DSS (2) MIS (3) ESS

20.Summary transaction data, high-volume data, and simple models are information inputs characteristic of a (n)
(1) DSS (2) MIS (3) ESS

21.Which of the following individuals typically have less formal, advanced educational degrees and tend to process rather than create information?
(1) Executives (2) System analysts (3) Data workers

22.An MIS provides
(1) past information (2) present information (3) All of the above

23._____ write computer programs that perform jobs specified by the user.
(1) Programmer (2) Data entry operator (3) System Analyst

24. A system must be composed of more than one____________
(1) subsystem (2) element (3) super system

25.External data is stored in the__________
(1) market forecast file (2) forecast allocation file (3)customer file

( 5 Marks)

1) What are different types of information?

2) Differentiate between decomposition of a system and integration of sub-systems.

3) What do you mean by Data Capturing?

4) What are various dimensions of information?

5) What do you mean by relevance of information?

(8 Marks)

1) Discuss the role of MIS in various phases of decision marking.

2) Explain various characteristics of MIS.

Unit-II

1. Controls of data communication deal with___________

(1) the communication channel (2) the computer (3) All of the above

2. The most prominent system in the retail sales industry is the _____ system.

(1) POS (point-of-scale) (2) COBOL (3) ACM

3. Data items in the fixed asset record of a newly purchased asset that a well-designed application program could obtain automatically include_________

(1) estimated disposal data (2) source (3) All of the above

4. A _____ provides a set of integrated computer tools that allow a decision maker to interact directly with computers in order to retrieve information useful for semi structured and unstructured decisions.

(1) DDS (2) DBMS (3) Control

5. Which of the following is not one of the qualitative characteristics that information must have______

(1) relevance (2) retrievability (3) all of the above

6. Management information systems usually__________

(1) Serve managers interested in weekly, monthly, and yearly results, not day-to-day activities (2) Help managers make decisions that are unique, rapidly changing, and not easily specified in advance. (3) Provide mangers with a generalized computing and telecommunications capacity that can be applied to a changing array of problems.

7. Decision support systems usually__________

(1) Serve managers interested in weekly, monthly, and yearly results, not day-to-day activities (2) Help managers make decisions that are unique, rapidly changing, and not easily specified in advance (3) Provide managers with a generalized computing and telecommunications capacity that can be applied to a changing array of problems

8. Identifying customers and markets using data on demographics, markets, consumer behavior,and trends is an example of a (n)_____________

(1) Operational-level sales and marketing information system (2) Knowledge-level sales and marketing information system (3) Management-level sales and marketing information system

9. Deciding where to locate new production facilities is a(n) example of a manufacturing and production information system operating at the____________

(1) Operational level (2) Management level (3) Knowledge level

10. Preparing short-term budgets is an example of a finance and accounting information system operating at the____________

(1) Operational level (2) Management level (3) Strategic level

11.Tracking employee training, skills, and performance appraisals is an example of a human resource information system operating at the ____________

(1) Operational level (2) Management level (3) Knowledge level

12. Assembling a product, identifying customers and hiring employees are____________

(1) Transactions (2) Phases (3) Business processes

13. Which of the followwing is a network of facilities for procuring materials, transforming raw materials inti intermediate and finished products, and distributing the finished products to customers__________

(1) Production Chain (2) Primary Chain (3) Supply Chain

14. Information systems can facilitate supply chain management by__________

(1) Tracking the status (2) Rapidly communicating orders (3) all of the above

15. Enterprise systems support___________

(1) Manufacturing processes (2) Financial and accounting processes (3) All of the above

16. A computer security protocol for logging in would be an example of the ______________ component of an information system.

(1) Software (2) Hardware (3) Procedure

17. Customer numbers and their names would be an example of the ______________ component of an order management information system.

(1) Software (2) Hardware (3) Data

18. No routine cognitive skills include_________

(1) Communication (2) Collaboration (3) All of the above

19. The quality of your _______is a large part of the quality of your information system.

(1) Computer (2) Time (3) Challenges

20. Which of the following is not a characteristic of good information___________

(1) Interchangeability (2) Relevance (3) Cost effectiveness

21. If you are a _____________ recipients 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__________

(1) Active (2) Passive (3) Proper

22. An _____ system has a stored knowledge base and an inference engine

(1) expert (2) centers (3) control

23. Data integrity refers to_________

(1) the simplicity of data (2) the privacy of data (3) the validity of data

24. The engineering change control system makes changes in the________

(1) operations file (2) production schedule (3) work force data

25. Header labels contain__________

(1) creation data (2) control totals (3) both (a) and (b)

(5 Marks)

1. What are common elements of any system?

2. Differentiate between MIS and Business expert system.

3. What is the role of database in information system?

4. What is the use of Decision Tree?

5. What do mean by os and oops ?

(8 Marks)

1. Explain the computer hardware trends in India?

2. Explain Client server computing with example?

Unit – III

1. The advent of personal computers____________

(1) will make our lives more productive (2) could cause us to lose some of our basic skills (3) All of the above

2. Data is gathered, describing what is happening in the__________

(1) input area (2) output area (3) All of the above

3. The way of thinking that might facilitate attainment of a single, integrated information system is the__________

(1) marketing concept (2) marketing mix (3) marketing grid

4. A characteristic of a distributed MIS structure is:___________

(1) computers supporting local DP operations (2) integrative sharing of the workload (3) All of the above

5. An information processor includes___________

(1) the data base and the model base (2) incoming data and outgoing information (3) incoming data, the central processing unit, the model base, outgoing information, and the data base

6. Translator for low level programming language were termed as____________

(1) Assembler (2) Compiler (3) Linker

7. Load address for the first word of the program is called__________

(1) Linker address origin (2) load address origin (3) Phase library

8. Symbolic names can be associated with_________

(1) Information (2) data or instruction (3) operation

9. A program in execution is called________

(1) Process (2) Instruction (3) Function

10. The scheduling in which CPU is allocated to the process with least CPU-burst time is called___________

(1) Priority Scheduling (2) Shortest job first Scheduling (3) Round Robin Scheduling

11. A human order taker can be bypassed when using a (n) _____________

(1) Office automation system (2) Management information system (3) Transaction processing system

12. Data mining cannot be done if___________

(1) Operational data has not been archived (2) Earlier management decisions are not available (3) The organization is large

13. Batch processing is preffered over on – line transaction processing when_________

(1) Processing efficiency is important (2) The volume of data to be processed is large (3) A large number of queries are to be processed

14. On-line transaction processing is used when__________

(1) It is required to answer random queries (2) It is required to ensure correct processing (3) All files are available on-line

15. Which is not a domain of Artificial Intelligence___________

(1) Virtual Reality (2) Expert System (3) None of the above

16. Which one of the following is used for evaluating credit risks__________

(1) Virtual Reality (2) Neural Network (3) Fuzzy logic

17. Which computer based model is developed after human brain___________

(1) Fuzzy logic (2) Neural Network (3) Virtual Reality

18. Knowledge based system supports _________

(1) Knowledge of creation (2) Knowledge of support (3) All of the above

19. Which of the system uses Multidimensional data analysis____________

(1) DSS (2) MIS (3) ESS

20. Cybernetic system is the one which is_________

(1) Self Monitoring (2) Self controlling (3) All of the above

21. Which of the following level of managers develop short-and medium-range plans, schedules, and budgets and specify the policies, procedures, and business objectives for their sub – units of thecompany________

(1) Strategic (2) Tactical (3) Operational

22. Information that is outdated, inaccurate, or hard to understand would be very meaningful, useful, or valuable to you or other business professionals_________

(1) True (2) False (3) Either True or False

23. Information has three dimensions. There are___________

(1) Time, consent, and form (2) Time, content and form (3) Cost, content and form

24. According to your text book, the emerging class of applications focuses on personalized decision support, modeling, information retrieval, data warehousing, what-if scenarios and reporting is called________

(1) Decision Support Trends (2) Decision Support History (3) Decision Support models

25. This dramatic expansion has opened the door to the use of which of the following tool________

(1) Business Intelligence(BI) (2) Business Knowledge (BK) (3) Business Ideas (BI)

5 Marks

1. What do you mean by network technology?

2. What do you mean by image processing?

3. What is electronic meeting system in MIS?

4. Write few trends in telecommunication?

5. Write short notes on DTP?

8 Marks

1. Explain the role of MIS in networking technology?

2. Write notes on (a) ECS (b) EMS.

Unit – IV

1. An assembler is __________

(1) programming language dependent. (2) syntax dependant. (3) machine dependant

2. Program ‘preemption’ is __________

(1) forced de allocation of the CPU from a program which is executing on the CPU (2) release of CPU by the program after completing its task. (3) forced allotment of CPU by a program to itself

3. Which of the following system ensures that proper stock of each item are maintained in an organization___________

(1) Human resource information system (2) An inventory control system (3) Manufacturing information system

4. Which of the following is a program that models the pattern recognition capabilities of the human brain_____________

(1) An expert system (2) Artificial Intelligence (3) Neutral network

5. ____________ is the process of defining the current problem, determining why a new system is needed, identifying the objectives of the proposed system.

(1) Feasibility analysis (2) System Analysis (3) System definition

6. The accounting system is ________whereas the demand forecasting system is ________

(1) deterministic, probabilistic (2) probabilistic, deterministic (3) open, close

7. The main hardware component used in the internet is____________

(1) Modem (2) Keyboard (3) Pinter

8. According to your text book, the Decision support systems use all of the following EXCEPT__________

(1) Analytical models (2) Specialized databases (3) Online transaction processing

9. _________________ were the original type of information system developed to support managerialdecision making. An MIS produces information______

(1) Management information systems (2) Decision Support systems (3) Management Tracking Systems

10. Which of the following involves analyzing complex relationships among thousands or even millions of data items stored in data marts, data warehouses, and other multidimensional databases to discover patterns, trends, and exception conditions________

(1) OLTP (2) OLAP (3) OISE

11. _______________represent complex data using interactive three-dimensional graphical forms such as charts, graphs and maps_________

(1) Data entry systems (2) Data Analysis systems (3) Data visualization systems

12. Another name of goal seeking analysis is________

(1) How to (2) How can (3) Why not

13. Decision support system involves all of the following types of analytical modeling activities except___________

(1) What-if analysis (2) Sensitivity analysis (3) Heuristics

14. In which of the following types of analysis, the value of only one variable is changed repeatedly, and the resulting changes on other variables are observed__________

(1) what if analysis (2) sensitivity analysis (3) Goal seeking analysis

15. In which of the following types of analysis, the goal is to find the optimum value for one or more target variables, given certain constraints___________

(1) what if analysis (2) optimization (3) Goal seeking analysis

16. ________________ is one of the most common and useful types of data mining for marketing. The purpose of market basket analysis is to determine what products customers purchase together with other products.

(1) Market Box Analysis (MBA) (2) Market of Business Administration (MBA) (3) Market Bazar analysis (MBA)

17. A user checks his email , looks up the current company stock price, checks his available vacation days, and receives an order from a customer-all from the browser on his desktop. That is the next –generation intranet,also known as__________

(1) corporate or enterprise information system (2) corporate or enterprise homepage (3) Corporate or enterprise homepage

18. In many organizations, hypermedia database at corporate intranet websites have become the knowledge bases for storage and dissemination of business knowledge________

(1) True (2) False (3) Either True or False

19. ___________ is a field of science and technology based on disciplines such as computer science,biology, psychology, linguistics, mathematics and engineering__________

(1) Natural intelligence (2) Artificial intelligence (3) Articulate intelligence

20. ___________ involves using multi- sensory human – computer interface that enable human users to experience computer – simulated objects, spaces, activities, and “words” as if they actually exist_______

(1) virtual office (2) virtual reality (3) Real reality

21. The components of an expert system include a ________________ that perform interfaces on the knowledge base and communicate answers to a user’s question.

(1) Database and software module (2) knowledge base and software module (3) communication base and software module

22. Information systems are composed of ___________basic components

(1) Four (2) three (3) two

23. The human order take cam be bypassed when using a(n)________

(1) Office automation system (2) Management information (3) transaction processing system

24. The _________ can help you choose a product

(1) Office automation system (2) Transaction processing (3) decision support system

25. The expert system uses a(n) ____________ to select the most appropriate response

(1) inference (2) decision support system (3) knowledge base

5 Marks

1. What is the importance of documentation in developing MIS?

2. How MIS is useful for Human Resource Department of an organisation?

3. What is the use of data dictionary?

4. What do you mean by Geographic Information system?

5. Write any few MIS application used for E-business?

8 Marks

1. Write notes on :  (a) Role of Human resource in MIS (b) Role of MIS in Banking and Governance.

2. Explain various MIS applications used in E-business?

Unit  - V

1. An intranet that is accessible by outside workers_________

(1) firewall (2) extranet (3) P2PN

2. _____________ is the capability to continue as if nothing has happended, even after a major component failure

(1) redundancy (2) interoperability (3) fault tolerance

3. striping with parity is also known as RAID____________

(1) 0 (2) 1 (3) 4

4. A storage device that is connected directly to a netwok ia an example of ______________

(1) network attached storage (2) storage area network (3) direct attached storage

5. A tape library will use a robotic component called a(n) ___________ to change and store multiple tape cartridges

(1) Backup device (2) redundant system (3) Auto loader

6. More than one of the same component is an example of a ______________ system

(1) Scalable (2) redundant (3) back up

7. Which type of database stores data in two – dimensional tables_________

(1) Network (2) Hierarchical (3) Relational

8. DBMS stands for ____________

(1) Detective Bureau Management System (2) Direct Base Management System (3) Data Base Management System

9. MICR stands for___________

(1) Magnetic Ink Character Recognition (2) Main Inter Connect Reader (3) Magnetic Inter Change Reader

10. WWW stands for___________

(1) World Width Web (2) World Wide Web (3) Whole World Web

11. __________is a voice output device.

(1) Mice (2) Speaker (3) Hub

12. MIS is defined as a system that aides management in making, carryout and controlling decision by_______

(1) Jerome Kanter (2) Frederick B. Cornish (3) Thomas R. Prince

13. Digital computers work on the principle of _________

(1) measurement (2) counting (3) both

14.The basic building block for all computer hardware is_________

(1) rod (2) chip (3) nip

15. MICR input device automatically reads characters printed along the ____________

(1) upper edge of cheques (2) upper side of DD (3) lower edge of cheques

16. Optical Mark Reader, Bar Code Readers, Optical Character Reader are_________

(1) MICR device (2) OCR device (3) OMCR device

17. FTP refers to___________

(1) File Transfer Protocol (2) Fax Transfer Protocol (3) Find Transfer Protocol

18. Network connections between the network is called as__________

(1) Intranet (2) Internet (3) Extranet

19. Pick out the one which is not a data model__________

(1) relational model (2) tree model (3) hierarchical model

20. EDI stands for__________

(1) Electronic Data Information (2) Electronic Data Interchange (3) electronic digital interchange

21. Plotter is used for___________

(1) text printouts (2) graphical printouts (3) storing data in secondary devices

22. A system must be composed of more than one__________

(1) subsystem (2) element (3) super system

23. External data is stored in the_________

(1) market forecast file (2) forecast allocation file (3) customer file

24 . Controls of data communication deal with__________

(1) The communication channel (2) the computer (3) All of the above

25.  An _____ system has a stored knowledge base and an inference engine.

(1) expert (2) centers (3) control

5 Marks

1. List out various advantages and disadvantages of financial MIS?

2. Define Subsystm?

3.  What are the types of system implication?

4. What do mean by pay roll system?

5.  What do you mean capital budget?

8 Marks

1. What are the various objectives and uses of  Accounting Information system? Explain.

2. How MIS is useful in financial Sector? Explain in context of railways?