Is the library setting in sharepoint enforcing check in and check out with versioning?

Just to follow up on what I see in terms of mirroring with suspended:

My Query:

select d.name, p.mirroring_role_desc, p.mirroring_state_desc from sys.database_mirroring p join sys.databases d on p.database_id = d.database_id where p.mirroring_guid...