Can sp_MSforeachDB be used for DBCC CheckDB without errors being masked?
It sounds like sp_MSforeachDB is skipping your Test2 database. This is one of many known issues with sp_MSforeachDB as noted by Aaron Bertrand:


Execute a Command in the Context of Each Database in SQL Server


You can confirm by removing the NO_INFOMSGS parameter:  

exec sp_MSforeachDB 'DBCC CHECKDB (?) WITH DATA_PURITY'


This should cause messages to be returned for every database. Search the results for your Test2 database. I bet it isn't there.

With DBCC CHECKDB all error messages are displayed by default. Specifying or omitting the WITH ALL_ERRORMSGS parameter has no effect.

You may like to look at Ola Hallengren's solutions for SQL Server Backup, Integrity Check, and Index and Statistics Maintenance.