10 questions
Explanation: ERP integrates all functional areas on one database, which reduces data redundancy. CRM covers customer relationships only, SCM the supply chain only, and CAD is for design drawings.
Explanation: OLAP means Online Analytical Processing and is used to analyse data across several dimensions. OLTP means Online Transaction Processing and records day-to-day transactions. The words analytical and transaction give the answer.
Explanation: Statements 1 and 2 are correct. Statement 3 is false because TPS serves the operational level. Once statement 3 is rejected, two options fall away at once.
Explanation: An exception report highlights only abnormal or out-of-limit cases so that managers can focus on what needs attention. A demand report is produced on request and a drill-down report moves from summary to detail.
Explanation: TPS operates at the operational level and records routine transactions such as fee receipts, attendance and payroll entries. DSS supports semi-structured decisions and EIS serves top management.
Explanation: Data mining searches large data sets for hidden patterns. A data warehouse is the consolidated store of historical data that mining works on, so the two are related but not the same.
Explanation: GIGO means Garbage In, Garbage Out: incorrect input data produces incorrect output however well the system is designed. The other options are invented expansions.
Explanation: Reporting only the cases that cross a set threshold is the defining feature of an exception report. Nothing was requested, so it is not a demand report, and no detail is being opened up, so it is not a drill-down report.
Explanation: A DSS uses models and what-if analysis to test the effect of different scenarios. The other three only record or process data and do not analyse it.
Explanation: An EIS or ESS serves the strategic level with summarised, graphical information and external data. MIS serves the middle level with periodic reports and TPS serves the operational level.
Back to Management Information Systems (MIS)