Oracle Distributed Processing Interview Questions and Answers

All Categories >> Oracle >> Distributed Processing >> ▼

Oracle Distributed Processing Interview Questions and Answer will guide us that an oracle distributed system consists of multiple autonomous computers that communicate through a computer network. Computers interact with each other in order to achieve a common goal. A program that runs in a distributed system is called a oracle distributed program, and distributed programming is the process of writing such programs. Learn Oracle Distributed Processing with this Interview Questions with Answers

  1. Oracle Distributed Processing questions updated at 01 Jul 10 in Category Oracle and visited 779 Times

Distributed Processing Questions and Answers:

1 :: What is Oracle Distributed database?

A distributed database is a network of databases managed by multiple database servers that appears to a user as single logical database. The data of all databases in the distributed database can be simultaneously accessed and modified.
0/5 Rating (0 vote)
Is This Answer Correct?    0 Yes 0 No
Place Your Answer

2 :: When will the data in the oracle snapshot log be used?

We must be able to create a after row trigger on table (i.e., it should be not be already available) After giving table privileges.
We cannot specify snapshot log name because oracle uses the name of the master table in the name of the database objects that support its snapshot log. The master table name should be less than or equal to 23 characters. (The table name created will be MLOGS_tablename, and trigger name will be TLOGS name).
0/5 Rating (0 vote)
Is This Answer Correct?    0 Yes 0 No
Place Your Answer

3 :: What are the options available to refresh Oracle snapshots?

COMPLETE - Tables are completely regenerated using the snapshots query and the master tables every time the snapshot referenced.
FAST - If simple snapshot used then a snapshot log can be used to send the changes to the snapshot tables.
FORCE - Default value. If possible it performs a FAST refresh; Otherwise it will perform a complete refresh.
0/5 Rating (0 vote)
Is This Answer Correct?    0 Yes 0 No
Place Your Answer

4 :: What are the various type of snapshots in Oracle?

Simple and Complex Snapshots
0/5 Rating (0 vote)
Is This Answer Correct?    0 Yes 0 No
Place Your Answer

5 :: How can we reduce the network traffic in Distributed Processing?

► Replication of data in distributed environment.
► Using snapshots to replicate data.
► Using remote procedure calls.
0/5 Rating (0 vote)
Is This Answer Correct?    0 Yes 0 No
Place Your Answer

Rate This Category:
0/5 Rating (0 vote)
 Place Your Question



Top: Oracle Distributed Processing Interview Questions and Answers
Oracle Distributed Processing Interview Questions and Answers

Top Frequently Asked Distributed Processing Question
Frequently Asked Distributed Processing Job Interview Question


Top Frequently opened Oracle Job Interview categories
Most popular Oracle Job Interview categories

Comments About Oracle Distributed Processing Interview Questions and Answers

Share your valuable opinions, ideas and suggestions about Oracle Distributed Processing Interview Questions and Answers
While placing your comment your email address is required but won't be published any where else; Personal information will be kept confidential; we do not sell or release our respective visitors private information.

  1. Webmaster 22nd of May 2012

    Webmaster Said

    Tell us what you feel about Oracle Distributed Processing Interview Questions and Answers
    All comments will be published after review. No login or registration is required to post a comment on Oracle Distributed Processing Interview Questions and Answers We offer and invite you to submit your valuable comment now; Please be respectful of others when commenting. Insulting others, self-promotional comments, website promotional comments, marketing stuff, SEO Techniques, SMS-style content and off-topic comments will not be approved at this information portal.
    So start sharing your thoughts regarding Oracle Distributed Processing Interview Questions and Answers
    Thank you.

    Reply

Leave a Comment

Leave a Comment
  4.  Enter This Verification Code  Regenerate Verification Code  



Your reply will be added to the comment above (Below any other replies to this comment) -

Top Comments About: Oracle Distributed Processing Interview Questions and Answers
Comments on Oracle Distributed Processing Interview Questions and Answers

 
Top of Link batk to Oracle Distributed Processing Interview Questions and Answers
Link batk to Oracle Distributed Processing Interview Questions and Answers

Privacy Policy | Terms and Conditions | Contact Us »