Section A: Multiple Choices (20 marks) Each question has 1 choice. 1 mark will be deducted for wrong answer for each question. 1. Which of the following is/are correct about sensitivity analysis? i. In sensitivity analysis, the varying constraints reflect real economy's uncertainties. ii. The estimates of inputs may include salaries, price, labour, growth rate. iii. Several scenarios are generated for comparison. iv. It is used to study the uncertainty between input and output of certain conceptual cases. v. Sensitive to CEOs or top managers moods. A. i, ii, v B. ii, iii C. i, ii, iii D. All of above. E. None of the above.

2. What is/are main differences between Transaction processing systems (TPS) and Management Information Systems (MIS): i. MIS generates exception, summary and drill down reports. ii. MIS helps mid-level management making decision in shared resources allocation. iii. MIS improves operational accuracy, efficiency as well as reducing costs. iv. MIS consolidates data to prepare for strategic plan. v. MIS allows users to build Ad-hoc report. A. i, ii, iii B. ii, iii C. iii D. All of above E. None of the above

3. Which of the following is/are component(s) of optimization using Excel Solver? i. The decision variables ii. The constraints iii. The loading iv. The policy v. The objective A. i, ii, iii, v B. ii, iii, iv C. i, ii, v D. None of the above E. All of the above

4. What is the potential issue with the data table below? i. Incorrect Dep_id ii. Data not in sorted order iii. Improper Emp_code iv. Spelling mistakes in names v. Redundancy in data A. i, ii B. ii C. ii, iv D. ii, v, E. v

5. Which of the following is incorrect about DBMS? i. A table must have primary and foreign keys. ii. The relationship between tables is established by linking primary key of one table to foreign key of another table. iii. In terms of relationship, there are none-to-none, 1-to-1, 1-to-many and many-to-many. iv. To increase the efficiency, TPS, MIS and DSS should have their own DBMS in a company. v. Majority of online shop are using MS Access as the primary DBMS. A. i B. i, ii C. ii, iii D. iv E. ii, v

6. Which of the following is NOT the common types of efficiency IT metrics? i. System availability - the number of hours a system is available for users ii. Conversion rates - The number of customers an organization touches for the first time and persuades to purchase its products or services. iii. Throughput - the amount of information that can travel through a system at any point iv. Customer satisfaction - Measured by such benchmarks as satisfaction surveys, percentage of existing customers retained, and increases in revenue dollars per customer. A. i, iv B. iii, iv C. ii, iv D. All of the above. E. None of the above.

7. Which of the following statement is/are FALSE?? i. Different types of information systems support management decision making at different levels. ii. Strategic level it solves long-term problems and establish organizational goals (1 to 5 years). iii. Operational level it solves short-term problems (a few months to a year) regarding resources allocation (e.g. human, raw materials, machine availabilities etc.) to meet objectives of top management. iv. Tactical level it solves frequent daily problems from supervision of day-to-day operations like order entry, credit checking, and inventory control. A. i, ii, iii B. ii, iv C. iii, iv D. All of the above E. None of the above.

8. Which of the following about TPS (Transaction Processing System) is/are TRUE? i. TPS is the earliest use of computers to reduce costs by automating routine, repetitive, labour-intensive business procedures. ii. TPS can be manual or automated. iii. TPS is an organized collection of people, robot, scanner, databases, and devices used to record completed business transactions. iv. TPS support the most fundamental, basic business operations of the organization; as it records every detail of each transaction. A. i, ii B. i, ii, iii C. i, ii, iv D. All of the above. E. None of the above.

9. Which of the following is/are the common Data Processing Activities in TPS? i. Data Manipulation - the actual processing inside the TPS such as calculations and data transformations related to the transactions. ii. Data editing - it detects for any errors, performs validity and completeness checking in input data. iii. Data collection - it captures and gathers all necessary data to complete transactions. iv. Data correction - if input data is valid, TPS should give appropriate error messages so that corresponding corrections can be made. A. i, iv B. i, ii, iii C. ii, iii, iv D. All of the above. E. None of the above.

10. Which of the following is/are NOT the report(s) produced from MIS (Management Information System)? i. Exception report and ad-hoc report ii. Investment opportunities report iii. Key-indicator report iv. 5-year sales forecasts report A. ii, iv B. i, ii C. i, iii D. All of the above E. None of the above.