CS614 Quiz 1 by VU Topper RM

Q1. Vu-Topper RM (1 marks)

The application of data and information leads to …….. ➢Power

➢Knowledge

Q2. Vu-Topper RM (1 marks)

➢1990s ➢1970s

Q3. Vu-Topper RM (1 marks)

.………..gives total view of an organization ➢Database

➢Data warehouse

Q4. Vu-Topper RM (1 marks)

The online high performance transaction processing was evolved in ➢1980 ➢1975

Q5. Vu-Topper RM (1 marks)

➢Wisdom

➢Information

Q6. Vu-Topper RM (1 marks)

Time variant is a characteristic of data warehouse which means: ➢Data cannot be loaded in data warehouse with respect to time

➢Data loaded in data warehouse will be time stamped

Q7. Vu-Topper RM (1 marks)

Ad-hoc access of data warehouse means: ➢That could not be accessed by any user

➢that does not have predefined database access pattern

Q8. Vu-Topper RM (1 marks)

For good decision making, one should be able to integrate data across the organization to give the……..of organization. ➢Total view. ➢Mid view.

Q9. Vu-Topper RM (1 marks)

Thegrowth of master files and magnetic tapes exploded in ………. ➢1950s ➢1960s.

Q10. Vu-Topper RM (1 marks)

Suppose the amount of data recorded in an organization is doubled every year. This increase is

➢Logarithmic

➢Exponental

Q11. Vu-Topper RM (1 marks)

The data in the data warehouse is ______________ ➢Volatile ➢Non -volatile

Q12. Vu-Topper RM (1 marks)

In decision support system ease of use in achieved by:

➢Denormalization

Q13. Vu-Topper RM (1 marks)

Decision support system queries deal with number of columns ———— ➢Having numeric values

➢Spanning across multiple tables

Q14. Vu-Topper RM (1 marks)

.History is excellent predictor of the __________. ➢Past

➢Future

Q15. Vu-Topper RM (1 marks)

Information can answer questions like “what”, “who” and “when” while knowledge can answer questions like ____________ ➢Why ➢How

Q16. Vu-Topper RM (1 marks)

The data has to be checked, cleansed and transformed into a format to allow easy and fast access ➢Proactive

➢Unified

Q17. Vu-Topper RM (1 marks)

known as

➢Legacy Systems Architecture

Q18. Vu-Topper RM (1 marks)

Identify data warehouse query from the following: ➢Directly maps to a star schema. ➢Not Directly maps to a star schema.

Q19. Vu-Topper RM (1 marks)

Relational databases allow you to navigate the data inthat is appropriate using the primary, foreign key structure within the data model.

➢Any Direction

➢Two Direction

Q20. Vu-Topper RM (1 marks)

____ facilitates a mobile computing paradigm. ➢ROLAP

➢MOLAP

Q21. Vu-Topper RM (1 marks)

As dimensions get less detailed (e.g., year vs. day) cubes get ____

➢Smaller

➢Larger

Q22. Vu-Topper RM (1 marks)

Suppose the size of the attribute “Computerized National Identity Card (CNIC) no” is changed in NADRA database. This transformation refers to:

➢Format revision

➢Field splitting

Q23. Vu-Topper RM (1 marks)

_________ provides a combination of “relational database access” and “cube” data structures

➢HOLAP

➢DOLAP

Q24. Vu-Topper RM (1 marks)

Robotic libraries are needed for ___________ ➢Cubes

➢Aggregates

Q25. Vu-Topper RM (1 marks)

Onlline Extraction is a kind of———————————data extraction.

➢Physical page

➢Multi valued

Q26. Vu-Topper RM (1 marks)

➢1960s