The Power of Adaptivity in Identifying Statistical Alternatives