Question
In indexing, which tree is most commonly used for
disk-based indexing because it minimizes disk seeks and keeps nodes dense?Solution
B+ trees are balanced, have high branching factor, and store keys in leaves enabling efficient disk-block utilization and range queries.
Which key uniquely identifies a record in a table?
The command to test reachability of a host in Linux is:
HTTPS ensures which of the following?
Which interrupt is generated by software?
During transaction before commit which of the following statements is done automatically in case of shutdown?
Distributed 2-Phase Commit (2PC) can suffer from:
Which SQL command is used to retrieve data from a table?
If every non-key attribute is functionally dependent on the primary key, the relation will be in
Bitmap indexes are most efficient when:
Which of the following is not part of the process control block (PCB)?