What are the benefits of distributed options in

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

233. What are the benefits of distributed options in databases?

Database on other servers can be updated and those transactions can be grouped together with others in a logical unit. Database uses a two phase commit.

(Continued on next question...)

Other Job Interview Questions

• How would you determine who has added a row to a table?
• Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
• What is SAVE POINT?
• Is it possible to link two groups inside a cross products after the cross products group has been created?
• What are the different windows events activated at runtimes?
• What is an Integrity Constrains?
• What is synchronize?
• What is SQL*Loader?
• Give the reasoning behind using an index.
• Can you have more than one content canvas view attached with a window?
• More...