It is possible that there could be a txid collision (and in fact they have occurred in the past due to a specific oversight in the protocol), but normally they are extremely unlikely because like private keys, they are effectively 256-bit random numbers. However, collisions are avoided by rejecting new txids duplicating txids of any transactions with unspent outputs (see
BIP-30).
Are these transactions actually rejected and deleted from mempool or these transactions are skipped and still waiting for the previous transaction with the same txid will be deleted from LevelDB?
I'm actually asking this question cause I've seen somewhere that when the UTXO is spent, it would be deleted from DB, am I right about it?