DWDM_Quiz1

__________ is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management decisions.

• A. Data Mining.

• B. Data Warehousing.

• C. Web Mining.

• D. Text Mining.

The data Warehouse is__________.

• A. read only

• B. write only

• C. read write only.

• D. none.

3. Expansion for DSS in DW is__________.

• A. Decision Support system.

• B. Decision Single System.

• C. Data Storable System.

• D. Data Support System.

4. The important aspect of the data warehouse environment is that data found within the data warehouse is___________.

• A. subject-oriented.

• B. Time-variant.

• C. Integrated.

• D. All of the above.

5. The time horizon in Data warehouse is usually __________.

• A. 1-2 years.

• B. 3-4 years.

• C. 5-6 years.

• D. 5-10 years.

6. The data is stored, retrieved & updated in ____________.

• A. OLAP

• B. OLTP.

• C. SMTP

• D. FTP.

7. __________describes the data contained in the data warehouse.

• A. Relational data.

• B. Operational data.

• C. Metadata.

• D. Informational data.

8. ____________predicts future trends & behaviors, allowing business managers to make proactive,

knowledge-driven decisions.

• A. Data warehouse.

• B. Data mining.

• C. Datamarts.

• D. Metadata.

9. __________ is the heart of the warehouse.

• A. Data mining database servers.

• B. Data warehouse database servers.

• C. Data mart database servers.

• D. Relational data base servers.

10. ________________ is the specialized data warehouse database.

• A. Oracle.

• B. DBZ.

• C. Informix

• D. Redbrick.