Database Questions: Q1: Q2:
Posted: Sat May 14, 2022 2:52 pm
Database Questions:
Q1:
Q2:
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.
Q1:
- Database Questions Q1 Q2 1 (24.66 KiB) Viewed 48 times
- Database Questions Q1 Q2 2 (22.45 KiB) Viewed 48 times
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.