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
Data Warehousing - CS614
flashcards
Decks in class (45)
# Cards
-
Chapter 112
-
Chapter 28
-
Chapter 38
-
Chapter 417
-
Chapter 54
-
Chapter 622
-
Chapter 78
-
Chapter 88
-
Chapter 910
-
Chapter 108
-
Chapter 118
-
Chapter 129
-
Chapter 1310
-
Chapter 1412
-
Chapter 1514
-
Chapter 1617
-
Chapter 178
-
Chapter 1814
-
Chapter 1923
-
Chapter 2010
-
Chapter 2124
-
Chapter 2224
-
Chapter 2315
-
Chapter 2425
-
Chapter 2513
-
Chapter 2615
-
Chapter 2715
-
Chapter 2816
-
Chapter 2910
-
Chapter 308
-
Chapter 3122
-
Chapter 3215
-
Chapter 339
-
Chapter 345
-
Chapter 353
-
Chapter 364
-
Chapter 376
-
Chapter 382
-
Chapter 398
-
Chapter 4013
-
Chapter 4116
-
Chapter 421
-
Chapter 434
-
Chapter 446
-
Chapter 454
