Explicit connection permits you precise control over which TDP and user ID to connect to, while implicit connection uses system defaults for the TDP and user ID. For this reason, any time you need to connect to a non-default TDP or user ID, you must make an explicit connection.
Explicit connections are preferable because they provide precise control, even when default TDPs and user IDs are sufficient to make a connection.