Report question

Question: Is MySQL Query containing sub-query atomic?