Management Information System Nptel Week 2 Answers
Are you looking for Management Information System Nptel Week 2 Answers ? All weeks solutions of this Swayam course are available here.
Table of Contents
Management Information System Nptel Week 2 Answers (July-Dec 2025)
Course link: Click here to visit course on Nptel Website
Question 1. What is a major problem associated with traditional file systems?
a) Real-time data analytics capability
b) High data redundancy and inconsistency
c) Seamless integration across departments
d) Automated business intelligence reporting
Question 2. Which of the following best describes a Database Management System (DBMS)?
a) A collection of unrelated spreadsheets used for data storage
b) A set of programs that manage the structure and access to a non-digital filing system
c) Software that enables users and applications to define, create, maintain, and control access to a database
d) A tool used primarily for designing graphical user interfaces (GUIs) for websites
Question 3. Which of the following is an example of relational DBMS?
a) Microsoft Excel
b) Oracle Database
c) Adobe Photoshop
d) Google Chrome
Question 4. What is the primary purpose of a foreign key in RDBMS?
a) To uniquely identify each record in a table
b) To store encrypted data in relational table
c) To enforce referential integrity by creating a link between two related tables
d) To speed up data retrieval through indexing
Question 5. Which of the following operations in a relational database is used to combine data from two or more tables?
a) SELECT
b) PROJECT
c) JOIN
d) SORT
Question 6. Which of the following best describes the purpose of an Entity-Relationship (E-R) Model in database design?
a) To generate executable code for managing the database
b) To describe how data is physically stored on disk
c) To visually represent data entities, their attributes, and relationships from the user’s perspective
d) To optimize SQL queries for faster performance
Question 7. Which of the following is an example of how OLAP is used?
a) Processing a credit card payment at a store
b) Analysing sales data across different regions and time periods to support business decisions
c) Editing a document on Google Docs
d) Sending a message through a chat application
Question 8. A school wants to understand which subjects students perform best in. They collect exam data, remove errors and missing values, then apply a tool to find patterns like “students who do well in Math also do well in Physics.” Which step of the KDD process does finding patterns like “Math and Physics performance are related” represent?
a) Data cleaning
b) Data Selection
c) Data Mining
d) Knowledge Presentation
Question 9. Which of the following correctly matches the analytics category with its example?
a) Descriptive Analytics — Forecasting future sales based on trends
b) Predictive Analytics — Generating real-time sales reports
c) Prescriptive Analytics — Recommending optimal inventory levels based on predicted demand
d) Descriptive Analytics — Suggesting best marketing strategies based on simulation
Question 10. Clustering, which is used to group similar data points without predefined labels, is best categorized under which type of analytics technique?
a) Descriptive Analytics
b) Predictive Analytics
c) Prescriptive Analytics
d) Diagnostic Analytics
These are Management Information System Nptel Week 2 Answers