COSC 460 Databases Midterm 2 Study Guide

The exam is closed book – no notes of any kind.

Topics

• Topics from first midterm
• SQL: aggregation and nesting
• Indexing, B+Trees and Extendible Hashing
• External merge sort
• Query evaluation, especially join algorithms