Imagine I have 2 UTXOs locked by my address, each of which allows me to spend 5 bitcoins.
If I subsequently want to send just 2 bitcoins to someone else, will both UTXOs be used as inputs in the transaction, where I now receive 8 BTC change as a single UTXO locked to my address, or as the value I want to spend can be covered by a single UTXO, is only one of the 5 BTC UTXOs spent by the transaction and I receive change in a new UTXO worth 3 BTC locked by my address. So now my address locks two UTXOs, one for 5 BTC which was not needed in this transaction, plus the change I just received for 3 BTC. Or something else?