NPTEL Management Information System Week 2 Assignment Answers 2024
1. Identify correct statements.
- Database system is secure in comparison to the traditional file system.
- Database system controls data redundancy
- Database system eliminates data inconsistency.
- Database system is simple to implement in comparison to the traditional file system.
a) 1,2
b) 1,2,3
c) 1,2,4
d) 1,2,3,4
Answer :- c
2. Which of the following is a diagrammatical representation of the logical structure of the database?
a) Flow chart
b) Entity-relationship diagram
c) Entity diagram
d) Tree diagram
Answer :- b
3. What are the main objectives of database normalization?
a) To increase data redundancy and complexity
b) To enhance query performance and add redundancy
c) To reduce data redundancy and ensure data integrity
d) To make the database structure more complex
Answer :- For Answer Click Here
4. How does a data mart differ from a data warehouse?
a) Data marts are smaller versions of data warehouses.
b) Data marts store only historical data.
c) Data marts are used for transactional processing.
d) Data marts focus on specific subjects or business lines.
Answer :- For Answer Click Here
5. In the given table, which attribute will be eligible for the primary key?
Employee (Employee _Id, Department _Id, Salary, Name)
a) Employee_Id
b) Department_Id
c) Salary
d) Name
Answer :-
6. State True/ False
Statement I: OLAP supports multidimensional data analysis.
Statement II: In OLAP, each attribute of the information is a different dimension.
a) Both statement I and statement II are true.
b) Statement I is True, and Statement Il is False.
c) Statement I is False, and Statement Il is True.
d) Statement I is False, and Statement Il is False.
Answer :-
7. Which type of data analytics focuses on identifying the root causes of past performance or events?
a) Descriptive analytics
b) Diagnostic analytics
c) Predictive analytics
d) Prescriptive analytics
Answer :- For Answer Click Here
8. Which technique is commonly used in predictive analytics to forecast future outcomes based on past data?
a) Regression
b) Decision trees
c) Support vector machines
d) Data visualization
Answer :-
9. Given data on customers’ past purchases, their browsing history, and demographics, your
model needs to predict the likelihood of each customer purchasing a new product. This is a:
a) Regression Task
b) Classification task
c) Clustering task
d) None
Answer :-
10. Which of the following is a predictive analytics application in retail?
a) Estimating future sales based on historical data and seasonal trends.
b) Tracking real-time inventory levels.
c) Analyzing customer feedback from surveys.
d) Managing employee work schedules.
Answer :- For Answer Click Here