Locks in RDBMS get released when

$($i$)$ Transaction is Committed

$($ii$)$ Transaction is Rolled back

$($i$)$ is True

$($ii$)$ is True

Both $($i$)$ and $($ii$)$ are True

Unlock command has to be issued explicitly