When the same data is updated in one location but remains unchanged in another location, it creates a state of what? MCQ with Answer and Explanation

Explanation:
Denormalization is a strategy applied to normalized databases where redundant data is selectively added to speed up complex read queries by minimizing costly table joins.

Explanation:
Strategies to handle deadlocks include timeout, lock ordering, and detection with rollback.

Explanation:
A Left Outer Join preserves all records from the left table, matching them with right table records when possible, or inserting NULL values if no match is found.