Database Administrator (DBA) Question:
Download Questions PDF

How can you Enforce Referential Integrity in snapshots?

Answer:

Time the references to occur when master tables are not in use. Perform the reference the manually immediately locking the master tables. We can join tables in snapshots by creating a complex snapshots that will based on the master tables.

Download Database Administrator (DBA) Interview Questions And Answers PDF

Previous QuestionNext Question
What is Two-Phase Commit?What is a SQL * NET?