Data Modeling Interview Questions

 
1.
Give us a non-computer example of preemptive and non-preemptive scheduling?
2.
What is the difference between star flake and snow flake schema?
3.
What is data sparsity and how it effect on aggregation?
4.
What is the difference between hashed file stage and sequential file stage in relates to DataStage Server?
5.
When should you consider denormalization?
6.
What is ERD?
7.
What is third normal form?
8.
Why are recursive relationships are bad? How do you resolve them?
9.
Is this statement TRUE or FALSE? all databases must be in third normal form?
10.
What is an artificial (derived) primary key? When should it be used?
11.
What is second normal form?