core_course_category::get_all() uses the cache and stores them in coursecatrecords. However, it does not use these cached records and still queries the DB every time it is called. So it kind of defeats the purpose of using the cache.