To understand the statements made about the OLAP CACHE, the user needs to know what OLAP CACHE is and how it works. OLAP CACHE is a technology that enables faster query processing by storing query results and navigation states in the application server memory. With that said, let's go through each statement and determine if it is true or false.

A. Query navigation states and query results are stored in the application server memory.

This statement is true. OLAP CACHE stores both query navigation states and query results in the application server memory, enabling faster query processing.

B. If the same query has been executed by another user the result sets can be used if the global cache is active.

This statement is also true. If the global cache is active, the result sets from a previously executed query can be used by another user who executes the same query, resulting in faster query processing times.

C. Reading query results from OLAP cache is faster than reading from the database.

This statement is also true. Because OLAP CACHE stores query results in the application server memory, reading those results is much faster than reading from the database, which requires I/O operations.

D. Changing the query will invalidate the OLAP cache for that query.

This statement is true. If a query is changed, the OLAP CACHE for that query will be invalidated because the query results and navigation state will no longer be valid for the new version of the query.

Therefore, the correct options are:

A. True B. True C. True D. True

The Answer is: D