Would transaction work across multiple DB in the same SQL server? If so, is this a Distributed transaction?

A transaction across multiple DBs in the same instance is a local transaction. BEGIN TRANSACTION will work just fine.