Database Questions Q1 Q2 1 (24.66 KiB) Viewed 47 times
Q2:
Database Questions Q1 Q2 2 (22.45 KiB) Viewed 47 times
Which of the following is FALSE regarding "sequential flooding"? The sequential flooding pollutes the buffer pool with pages that are read once and then never again. The sequential flooding is caused by a query performs a sequential scan that reads every page. The LRU replacement policy is susceptible to sequential flooding. The CLOCK replacement policy is immune from the sequential flooding.
Consider a hash table (hash function and hashing scheme) and its main characteristics. Which of the following is FALSE ? Linear Probe Hashing is the most basic hash function. A hashing scheme handles key collisions after hashing. A hash table provides on average O(1) operation complexity. O A hash function's output is deterministic.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!