Yes, that is correct. I would be tempted to say "added" rather than "inserted" -- seems to me it will be better understood by users.

>>"Did the record get inserted?"
>
>I verified and I used the first one.
>
>>
>>"Was the record inserted?"
>>
>>"Has the record been inserted?"
>>
>>are all correct.