If you attempt to install a package that contains a file that has already been installed by another packages, you'll see:
# rpm -ivh foo-1.0-1.i386.rpm foo /usr/bin/foo conflicts with file from bar-1.0-1 error: foo-1.0-1.i386.rpm cannot be installed
To cause RPM to ignore that error, use -replacefiles on the command line.