I'd go with the documentation. If you don't specifiy a value at create time the table is created NOCACHE. If you ALTER TABLE after the table is created (and when else would you "alter table") and you don't specifiy a value, then the existing value is unchanged.