Oracle Interview questions


Total available count: 35
Subject - Databases
Subsubject - Oracle

What are materialized views?

These are schema objects that are used to summarize, compute, distribute, and replicate data. They can be used in various environments for computation such as distributed or mobile computing, decision support, and data warehousing and it also provides local access to data rather than accessing from remote sites. In data warehouses, Materialized Views(MVs) are used to compute and store aggregated data.




Next 5 interview question(s)

1
What is a view?
2
What are data blocks?
3
What is a Tablespace?
4
What contains oracle physical database structure?
5
How does Oracle work?