Skip to main content

MIS MCQs on Information System, Data-Information-Knowledge and Knowledge Management System

Hello Everyone!

This is another article based on MCQs, related to Management Information System. These are the general MCQs which are commonly asked in exams and include topics like the basic introduction to Information System and its types, Data-Information-Knowledge and Knowledge Management System.



Learn more about the "Information system and its types".
Also check out the First Part  and Second Part of Social Computing MCQs.

Q 1) A data warehouse is which of the following?

a. Can be updated by end users
b. Organized around important subject areas
c. Contains numerous naming conventions and formats
d. Contains only current data

Solution: b) Organized around important subject areas

Q 2) A goal of data mining includes which of the following?

a. To create a new data warehouse
b. To explain some observed event or condition
c. To confirm that data exists
d. To analyze data for expected relationships

Solution: b) To explain some observed event or condition

Q 3) A snowflake schema is which of the following types of table?

a. Helper
b. Fact
c. Dimension
d. All of the above

Solution: d) All of the above

Q 4) A star schema has what type of relationship between a dimension and fact table?

a. One to one
b. One to many
c. Many to many
d. All of them

Solution: b) One to many

Q 5) An _____ is a set of entities of the same type that share the same properties, or attributes.

a. Entity set
b. Relation set
c. Attribute set
d. Entity model

Solution: a) Entity set

Q 6) Data scrubbing is which of the following?

a. A process to load the data in the data warehouse and to create the necessary indexes
b. A process to upgrade the quality of data before it is moved into a data warehouse
c. A process to reject data from the data warehouse and to create the necessary indexes
d. A process to upgrade the quality of data after it is moved into a data warehouse.

Solution: b) A process to upgrade the quality of data before it is moved into a data warehouse

Q 7) Data transformation includes which of the following?

a. Separating data from one source into various sources of data
b. A process to change data from a summary level to a detailed level
c. Joining data from one source into various sources of data
d. A process to change data from a detailed level to a summary level

Solution: b) A process to change data from a summary level to a detailed level

Q 8) Entity is a ______.

a. Thing in real world
b. Object of relation
c. Present working model
d. Model of relation

Solution: a) Thing in real world

Q 9) Fact tables are which of the following?

a. Partially denormalized
b. Partially normalized
c. Completely normalized
d. Completely denormalized

Solution: c) Completely normalized

Q 10) Identify the step of KMS. Like a library the knowledge must be kept current.

a. Create
b. Capture
c. Refine
d. Manage

Solution: d) Manage

Q 11) Point out the wrong statement.

a. Data is factual information for analysis
b. BI is a category of database software that provides an interface to help users quickly and interactively scrutinize the results in a variety of dimensions of the data
c. Customer relationship management entails all aspects of interaction that a company has with its customers
d. None of the above

Solution: b) BI is a category of database software that provides an interface to help users quickly and interactively scrutinize the results in a variety of dimensions of the data

Q 12) The generic two-level data warehouse architecture includes which of the following?

a. Data that can extracted from numerous internal and external sources
b. Near real-time updates
c. At least one data mart
d. All of the above

Solution: d) All of the above

Q 13) The set of processes developed in an organization to create, gather, store, transfer, and apply knowledge, best describes ________.

a. Organizational learnings
b. Knowledge management
c. Organizational memory
d. Knowledge assets

Solution: b) Knowledge management

Q 14) A ____ is a system where operations like data extraction, transformation and loading operations are executed.

a. Data staging
b. ETL
c. Data integration
d. None of the above

Solution: a) Data staging

Q 15) Data mining is used for _____.

a. Customer profiling
b. Text mining
c. Web analysis
d. All of the above

Solution: d) All of the above

PAGE 1 | PAGE 2 | PAGE 3 | PAGE 4 | PAGE 5 | PAGE 6 | PAGE 7

Comments

Popular posts from this blog

50 + Interview Questions/Experiences of TCS DCA April 2021

Hello Everyone! This post is dedicated to the Interview Questions asked in TCS DCA. DCA which is Digital Capability Assessment is usually conducted for the internal employees of TCS who are selected for the Ninja profile. If DCA is cleared successfully, then the candidates are offered Digital profile. That means the profile changes from Assistant System Engineer to System Engineer . This year i.e., in 2021, TCS conducted DCA for the candidates who have received offer letter but not joined TCS as an employee yet. The original DCA which is conducted for internal employees has a different pattern and is not discussed in this post. Rather this post is dedicated to the DCA conducted in March and April 2021 for 2021 recruits. The DCA was conducted on 19 th and 20 th March 2021. The test had two coding questions. To sucessfully clear DCA, all the test cases of both the codes must be passed. In March DCA, a lot of students faced compile...

UML - Object Diagram for Hospital Management System

Hello Everyone! Here is an example of an Object Diagram for Hospital Management System. Problem Statement - The hospital wishes to maintain a database to assist with the administration of its wards and operating theatre and to maintain information related to its patients, surgeons and nurse. Most patients are assigned to a ward on admittance and each ward may contain many patients. However, consultants (senior surgeons) in the hospital may have private patients who are assigned to private room. A nurse may or may not be assigned to a ward and she cannot be assigned to more than one ward. A ward may have many nurses assigned to it. Each ward is dedicated to a particular type of patient. A nurse may or may not be assigned to a theatre and she cannot be assigned more than one theatre. Theatre may have many nurses assigned to it. A patient may have number of operations. The information to be recorded about the operation includes the type of operation, the patients, the surgeons involv...

UML - Activity Diagram for Vending Machine

Hello Everyone! Here is an example of an Activity Diagram of a Vending Machine. Problem Statement - A vending machine accepts coins for a variety of products. The user selects the drink from products available through selection panel. If the drink is available the price of the product will be displayed. The user then deposits the coins depending on the price of the product. Coin collector collects coin after stipulated time. The controller will compare the deposited coins with the price. If amount is less than the price then an error message will be displayed and all deposited coins will be dispensed by the dispenser. Otherwise the drink will be displayed by the drink dispenser. Check out other UML (Unified Modeling Language) Diagrams - Use Case Diagram   Class Diagram   Object Diagram   Sequence Diagram Collaboration Diagram   State Diagram   Component Diagram   Deployment Diagram