what are different types of partitioning in oracle ?
- 3 Answers
- 10572 Views
- I also Faced
- E-Mail Answers
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 |
How to pivot data using informatica when you have variable amount of pivot rows?
What is the goal of optimizer?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
What is the difference between olap and oltp?
Where do we use semi and non additive facts?
what is indexing ? what are different types of indexes supported by oracle ?
What is surrogate key? Where we use it? Explain with examples.
What is the difference between static cache and dynamic cache?
What is an OLTP (Online Transaction Processing) System?
What are the data types present in bo?
What Oracle features can be used to optimize my Warehouse system?
what is parallelism?
Teradata 
