These tests would be stronger if they also tested a replicated table mat view and one that was based on a partitioning on dept, all populated with the same rows and getting the same results.