Database Administrator (DBA) Question:

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.


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