GeekInterview.com
  I am new, Sign me up!
 

Oracle Distributed Processing Interview Questions


Oracle Distributed Processing Interview Questions

Questions: 19
Comments: 0
 Oracle Distributed Processing Tags
 Showing Questions 1-10 of 19 Questions
[1] 2 Next >>
 Sponsored Links

 
 Oracle Distributed Processing Interview Questions
Sorting Options :  

.1. How pipeline promotes parallel processing?Explain with examples.2. Mention the Hardware issues involved in parallel processing? 3.Give the purpose of having buses in distrubuted parallel processing? 
View Question | Asked by : santosh

View Question | Asked by : vachaspati

 Simple and Complex. 

     - Replication of data in distributed environment.     - Using snapshots to replicate data.     - Using remote procedure calls. 

 Snapshot is an object used to dynamically replicate data between distribute database at specified time intervals. In ver 7.0 they are read only. 

      -  A  simple snapshot is based on a query that does not contains GROUP BY clauses, CONNECT BY clauses, JOINs, sub-query or snashot of operations.     

 Updating or Inserting records in remote database through database triggers. It may fail if remote database is having any problem. 

 Time the references to occur when master tables are not in use. Peform the reference the manually immdiately locking the master tables. We  can join  tables in snopshots by creating 

 COMPLETE   -   Tables   are completely regenerated using the snapshots query and the master tables every time the snapshot referenced.FAST  - If simple snapshot 

 It  is a table that maintains a record of modifications to the master table in  a  snapshot.  It is stored  in the same database as master table and is only  available 

View page [1] 2 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Expert Members
# User Name Count
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape