Usually the car will not start. Win you turn your key to the on position, you should hear a "whine" from your tank, signalling that the fuel pump is working. If your relay is bad, the pump won't come on (although this can also be a bad fuel pump).
Another way to check is to have someone else turn the key to on while you listen for the relay to click. It's pretty quiet, so you have to listen really close.