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

No, at the point you will activate your table a same transparent table is going to be create in database.