what are different types of partitioning in oracle ?

Question Posted / jakki

Answers were Sorted based on User's Feedback

what are different types of partitioning in oracle ?..

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

what are different types of partitioning in oracle ?..

Answer / msb.dwh

HASH
RANGE

Is This Answer Correct ?

7 Yes

11 No

what are different types of partitioning in oracle ?..

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

More Data Warehouse General Interview Questions

Explain what are the mapping paramaters and maping variables?

What are the primary ways to store data in OLAP?

What is operational data store (ods)?

What are the mapping paramaters and maping variables?

What is the purpose of Dataware Control?

Why should we use data ware housing and how can you extract data for analysis with example?

Can a dimension table contain numeric values?

What is conformed fact?

what are the other factors of the database on which the loading performance depend?

What are non-additive facts in detail?

three ways sql*loader could load data, what are those three types?

Explain datawarehousing?

For more Data Warehouse General Interview Questions Click Here