Does link scope have any effect for executables?

I’ve seen people write all of the following:

target_link_libaries(example someLibrary)
target_link_libaries(example PRIVATE someLibrary)
target_link_libaries(example PUBLIC someLibrary)

Is there any difference between the first one and the others? You can’t link executables to anything right?