vuexpert@gmail.com

1. _______is the one class of decision support environment
2. Normally selectivly query in OLTP system is __________
3. Normaly selctvily query in dataware house is _______
4. Prejoining technique is used to avoid demoralization normally slow down_______
5. The most common base of range partitioning in data warehouse is on _______
6. Full and incremental techniques are the type of _________
7. Dm techniques focus on the concept of ____ and ____
8. Data Extraction from Source system is a difficult task because source system is______
9. It is called a _____ violation if we have null values for attributes where not null constraints exists
10. All data is _________ of some thing real
11. In System the contents change with time (T/F)
12. If we remove the modification anomalies the table come ____ form

Subjective type questions

Q1) How dimension can be identified ? Explain with a suitable example? (3)

Q2) Describe physical extractions what is the difference offline and online extraction?(5)

Q3) We can classify anomalies in how many classes. Discuss each class of anomaly in detail?