Explain the difference between SQL invalidation and SQL notification.

1.	Explain the difference between SQL invalidation and SQL notification.
Answer» SQL invalidation directly invalidates the data present in the cache when a change is applied in the database that is copied to cache EARLIER. COMPARED to this, SQL notification triggers only when there is a change in the data that is MADE a copy in the cache.

Discussion