CS614 Final Term Past Papers by Rajpoot

CS614-DATA WAREHOUSING · Final Term Past Paper · (Updated spring 2022)

1. Multi-dimensional databases (MDDs) typically use proprietary __________ formats to store pre summarized cube structures. File
2. Many DW projects do not deliver to full potential because they treat data quality as a one- time undertaking as part of (UAT). Hence UAT stands for: user acceptance testing

Q3. Which is the least appropriate join operation for Pipeline parallelism?

Sort-merge joins

4. Implementing a data warehouse requires _________ integrated activities.

Tightly

5. The application development quality-assurance activities cannot be completed until the data is________.

stabilized

6. ______________is an application of information and data.

Knowledge

7. Parallel execution dramatically reduces response time for ________ operations on large databases typically associated with Decision Support Systems (DSS) and data warehouses.

Data-Intensive

8. If every key in the data file is represented in the index file then index is

Dense Index

9. There are many variants of the traditional nested-loop join. If the index is built as part of the query plan and subsequently dropped, it is called ____________________.

Temporary index nested-loop join

10. ________ Division is cotton hub of Punjab. Multan
11. Punjab is the __________ of Pakistan, and administratively divided into eight divisions.

bread-basket

12. If some error occurs, execution will be terminated abnormally and all transactions will be rolled back. In this case when we will access the database, we will find it in the state that was before the ____________. Execution of package
13. Execution of package can be completed successfully or it may be stopped due to some error. If some error occurs, execution will be terminated abnormally and all transactions will be

Rolled back

14. If some error occurs, execution will be terminated abnormally and all transactions will be

Rolled back

15. Identify the TRUE statement about Hypertext Transfer Protocol (HTTP).

HTTP is stateless protocol

16. The ith bit is set to 1 if the ith row of the base table has the value for the indexed column.

Bitmap index

17. For a K-means clustering algorithm:

t is much smaller than n