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 |
How can you set the client management?
what is the difference between MOLAP and ROLAP?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
Explain the definition of normalized and denormalized view?
What is cfapplication tag?
what are different storage options supported by oracle ?
What is conformed fact?
Can we have more than one time dimensions in a Schema(Star or Snowflake)
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What is Bulk Insert?
What is fact less fact table? Where you have used it in your project?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?