How can you Enforce Referential Integrity in sna

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

(Continued from previous question...)

225.How can you Enforce Referential Integrity in snapshots?

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 a complex snapshots that will based on the master tables.

(Continued on next question...)

Other Job Interview Questions

• What UNIX command will control the default file permissions when files are created?
• What is SQL*Loader?
• What use of command line parameter cmd file?
• Give the stages of instance startup to a usable state where normal users may access it.
• What is an user exit used for?
• What is the diff. when confine mode is on and when it is off?
• What is Distributed database?
• What are the uses of rollback segment?
• Explain the difference between a hot backup and a cold backup and the benefits associated with each.
• How do you set up tablespaces during an Oracle installation?
• More...