On cohomologically complete intersections