Answer the following statement(s) true (T) or false (F)

Question

1. An in-memory database (IMDB) is a database management system that stores an entire database in read-only memory (ROM).
2. In spreadsheets programs, Excel Solver can be used by the end users to perform “what if” analysis for the evaluation of various alternatives.
3. Online analytical processing (OLAP) enables users to identify issues and opportunities as well as perform trend analysis.
4. Online analytical processing (OLAP) involves the interactive examination of high-level summary data in increasing detail.
5. Case-based reasoning technique of data mining contains a specialized set of algorithms that sorts through data and forms statistical rules about relationships among the items.

Answer 1

1.FALSE
An in-memory database (IMDB) is a database management system that stores an entire database in random access memory (RAM). This approach provides access to data at rates thousands of times faster than storing data on some form of secondary storage (e.g., a hard drive or flash drive), as is done with traditional database management systems.
2.TRUE
Online analytical processing (OLAP) is a method to analyze multidimensional data from many different perspectives. It enables users to identify issues and opportunities as well as perform trend analysis.
3.False
Business managers often import data into a spreadsheet program, which then can perform operations on the data based on formulas created by the end user. Spreadsheets are also used to create useful reports and graphs based on that data. End users can even employ tools such as the Excel scenario manager to perform “what if” analysis to evaluate various alternatives or Excel Solver to find the optimal solution to a problem with multiple constraints (e.g., determine a production plan that will maximize profit subject to certain limitations on raw materials).
4.FALSE
Drill-down analysis involves the interactive examination of high-level summary data in increasing detail to gain insight into certain elements—sort of like slowly peeling off the layers of an onion.
5.FALSE
Case-based reasoning involves the usage of historical if-then-else cases to recognize patterns.