Name collision occurs when two or more identifiers in a system are unintentionally given the same name, leading to potential malfunctions, errors, or security vulnerabilities. In the realm of Domain Name System (DNS), name collisions can arise when private namespaces are inadvertently exposed to the public domain, creating conflict between intended and unintended use.