Can a transparent table exist in data dictionary but not in the data base physically?

No.
Transparent table do exist with the same structure both in the dictionary as well as in the database, exactly with the same data and the fields.