I mean, even if there are no record found for "query" under IF EXISTS (query), the alter database get executed.

Query returns zero record but alter database statement gets executed.