What is the differnece between materialized view and snapshot | Interview Question

Q&A Categories

Applications
Business-Objects
Clarify-CRM
- AJAX
- CSS
- CSS3
- Html
- java-Script
- VB-Script
Concepts
- Data-Modeling
- Data-Structures
- OLAP
- OOPS
- UML
Data-Warehouse
- Abinitio
- Analysis-services
- Business-Intelligence
- Cognos
- Concepts-and-Architecture
- Data-Warehouse-General
- DataStage
- Designer
- ETL
- Informatica
- MicroStrategy
- Reportnet
Database
- Btrieve
- Database-Admin
- Firebird
- Informix
- Microsoft-Access
- MYSQL
- PostgreSQL
- SAP-DB
- SQL
- SQL-server-2000-interview-questions
- Stored-Procedures
- Sybase
- Unify
General
- Career-Goals
- Creativity
- Flexibility
- Human-Resources
- Interests
- Job-Peformance
- Leadership
- Motivation
- Personal-Interview
- Self-Assessment
- Skills
Help-Desk
J2EE
- Core-Java
- EJB
- Hibernate
- Java
- Java-Patterns
- JDBC
- JMS
- JSP
- Ruby
- Servlets
- Struts
- Websphere
Languages
Mainframe
- CICS
- COBOL
- DB2
- IDMS
- JCL
- VSAM
Management
- Business-Analyst
- Citrix
- Desktops
- Lotus-Notes
- MBA
- Network
- Project-Manager
- Servers
- Team-Lead
Microsoft
- Ado-NET
- Architecture
- ASP
- ASP-NET
- Basics
- C-Sharp
- DataGrid
- DotNet
- Mixed
- VB-NET
- Visual-Basic
Microsoft-NET
Networking
- Bluetooth
- Client-Server-Computing
- Computer-Networks
- Networks-and-Security
Operating-System
- Shell-Scripting
- Solaris-Admin
- UNIX
- Unix-Commands
- Unix-Programming
- Windows-Unix
Oracle
- Backup-and-Recovery
- D2K
- Data-Access
- Database-Administration
- Database-security
- Distributed-Processing
- Memory-Management
- Oracle-Forms-3-0
- Oracle-Forms-4-0
- Oracle-General
- PL-SQL
- Programmatic-Constructs
- RMAN
- Scenarios
- SQL-Plus
- System-Architecture
Oracle-Apps
- Application-Object-Library
- Component-Interface
- Flexfields
- Forms-Customization
- HRMS
- PeopleCode
- PeopleTools
- PS-Admin
- PS-Mixed
- Scope-and-Application
- Segment-Security
- SQR
- Technical
- test
Peoplesoft
Programming
- Alogirthms
- C
- C-Plus-Plus
- ColdFusion
- Delphi
- Perl
- PHP
- Python
- VBA
- VoiceXML
- XML
SAP-R-3
- ABAP
- BDC
- Internal-Tables
- Modules
- Reports
- SAP-Admin
- sd
Siebel
- Siebel-General
Testing
- Bug-Tracking
- Common
- Common-Questions
- DataBase-Testing
- Discussion
- Load-Testing
- Product-Testing
- QA-Testing
- Quality-Control
- Quality-Management-
- Security-Testing
- Software-Testing
- Test-Automation
- Test-Cases
- Testing-General
- Testing-Scenarios
- Web-Testing
- Whitebox-Testing
- Wireless-Testiing
Testing-Tools
- LoadRunner
- QTP
- Rational-Robot
- SilkTest
- Test-Director
- Winrunner
Web
Accounting-Reports
Accounts-Payable
Accounts-Receivables
Audit
Cashier
Cost-Accounting
Fixed-Assets
General-Ledger
Payroll
Supervisory

What is the differnece between materialized view and snapshot

Aug

27

2010

What is the differnece between materialized view and snapshot A materialized view is a replica of a target master from a singlepoint in time. The concept was first introduced with Oracle7 termed asSNAPSHOT. In Oracle release 7.1.6 snapshots were enhanced to enableDMLs along with a new terminology, updatable snapshots. With Oracle8.1.6 snapshots started to be used in data warehouse environments so anew terminology materialized view was introduced to address bothdistributed and data warehouse materialized views.’

In: Concepts-and-Architecture Asked By: sunil [

]

Answer this Question Now

No Answers yet, be the first to Answer!

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »

Sign Up

Get all of your questions answered now!

Member Log In

Star Points Scale

Earn points for Asking and Answering Questions!

Grey Sta Levelr

[1 - 25

]

Green Star Level

[26 - 50

]

Blue Star Level

[51 - 500

]

Orange Star Level

[501 - 5000

]

[5001 - 25000

]

Black Star Level

[25001+

]