what are different types of partitioning in oracle ?
Answers were Sorted based on User's Feedback
Answer / sabeena
In Oracle you can partition a table by
• Range Partitioning
• Hash Partitioning
• List Partitioning
• Composite Partitioning
| Is This Answer Correct ? | 42 Yes | 3 No |
Answer / sachs
Partition by good bad
Partion by rich poor
Partition by boy girl
Partition by right wrong
| Is This Answer Correct ? | 4 Yes | 30 No |
Explain the definition of normalized and denormalized view?
Why denormalization is promoted in universe designing?
Why joiner transformation does not allow the aggregator transformation and expression transformation to join
Name at least three brands of Database Management Systems
What is surrogate key? Explain with examples.
1.WHAT IS DATA MART ?
How we are using this function?
How to reduce warnings?
how can one connect two fact tables ? is it possible ? how?
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
3 Answers Extech, Principal Finance,
What is execution plan?
What is Grain & Granularity in Data Warehouse.