Database Administrator (DBA) Question:

Download Job Interview Questions and Answers PDF

How can you Enforce Referential Integrity in snapshots?

Database Administrator (DBA) Interview Question
Database Administrator (DBA) Interview Question

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?