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.