What are snapshots? What are materialized views & where do we use them? What is a materialized view?
Submitted by: AdministratorMaterialized view is a view in wich data is also stored in some temp table.i.e if we will go with the View concept in DB in that we only store query and once we call View it extract data from DB.But In materialized View data is stored in some temp tables.
Submitted by: Administrator
Submitted by: Administrator
Read Online Oracle ETL Job Interview Questions And Answers
Top Oracle ETL Questions
| ☺ | What are the various methods of getting incremental records or delta records from the source systems? |
| ☺ | What is partitioning? What are the types of partitioning? |
| ☺ | Where do we use connected and un connected lookups? |
| ☺ | What are snapshots? What are materialized views & where do we use them? What is a materialized view log? |
| ☺ | Compare ETL & Manual development? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
