Advanced database

1. Consider the following three pages (ref is reference counter and clock pointer points to P₁) in the buffer pool and assume the following access sequence A, B, C, A of blocks from disk. Determine contents of the pages P₁, P₂, and P₃ and values of ref for every page under clock replacements policy.

P1, ref = 1 P2, ref = 0 P3, ref = 0 1