B+ Trees Multiple Choice Questions (MCQ) PDF - 28

MCQ 136: The nonleaf nodes of the B+- tree structure form a

1. Multilevel clustered indices
2. Sparse indices
3. Multilevel dense indices
4. Multilevel sparse indices

MCQ 137: An approach named Lock timeouts is used for

1. Deadlock detection
2. Deadlock elimination
3. Deadlock recovery
4. Deadlock prevention

MCQ 138: Data dictionary cache is also known to be

1. Row cache
2. Attribute cache
3. Tuple cache
4. Column cache

MCQ 139: The commands are all expressed in a language called

1. Java
2. SQL
3. PHP
4. .Net

MCQ 140: To maintain materialized views, we can use

1. Triggers
2. Pointers
3. Clone objects
4. Cascading