Questions on Data Warehousing concept

1. What is Data Warehouse?

2. What is difference between Data Warehouse and Data Mart ?

3. What is Star schema?

4. What is Snow-flake schema?

5. What is fact and dimension?

6. What is surrogate key?

7. What Normlisation ?Explain 3rd Normlised form?

8. What is the difference between OLTP and OLAP?

9. Are you involved in data modeling ?If yes which tool/tech you are using?

10. Which schema modeling techniques you ever used?

11. What do you mean by summary table?

12. What Degenerated Dimensions

13. What is fact less fact?



Oracle question based on data warehouse?

1 What is parallel execution

2 What is Bitmap and B-Tree indexes ? Explain Local Vs Global variables

3 What is materialised view

4 What is page size/array size in oracle?

5 What are integrity constraints ?

6 How can one tune SQL’s in Oracle?