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

How can we acheive correlated sub-query in designer?can anyone help me in this regard?

Why null values are mapped as 0 in fact tables?

How can we load the time dimension?

Explain what is type 2 version dimension?

What is surrogate key? Where we use it?

What is Star Schema?

Explain what are the advantages data mining over traditional approaches?

What is conformed dimension?

What is called data cleaning?

Explain difference between data ware house & data mart?

What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh

What is data analytics in simple terms?

For more Data Warehouse General Interview Questions Click Here