Database Questions: Q1: Q2:
Posted: Sat May 14, 2022 2:55 pm
Database Questions:
Q1:
Q2:
In the the buffer pool, ________ tracks the number of threads that are currently accessing that page (either reading or modifying it). dirty flag latch pin counter page directory
A________ is a replica of a subset of a table's columns that is organized in such a way that allows the DBMS to find tuples more quickly than performing a sequential scan. prefix hash function candidate key table index suffix
Q1:
- Database Questions Q1 Q2 1 (13.86 KiB) Viewed 47 times
- Database Questions Q1 Q2 2 (17.23 KiB) Viewed 47 times
A________ is a replica of a subset of a table's columns that is organized in such a way that allows the DBMS to find tuples more quickly than performing a sequential scan. prefix hash function candidate key table index suffix