Chapter 9 Flashcards
1
Q
Is it true effects of de-normalization on database performance are unpredictable
A
Yes
2
Q
What should be the logical model normalization level, if de normalization has to be taken
A
3NF
3
Q
What are trade-offs of de-normalization
A
Performance
Ease-of-use
Maintenance
Storage
4
Q
What is formula of sorting
A
O(n log n)
5
Q
Does Horizontal splitting a Divide&Conquer technique
A
Yes
6
Q
Can we reverse Round robin and random splitting
A
No
7
Q
What are hot spots
A
uneven distribution of data
8
Q
Does Range and expression splitting leads to hot spots
A
Yes
9
Q
Which one is cheapest partitioning algorithm
A
Round-robin
10
Q
What is the most common use of range partitioning
A
on date
