I'm having trouble understanding this content in college and finding good materials to understand, could someone explain to me better how transactions are specified and the delimiters defined in the DBMS, in particular SQL Server? How does it also treat the level of competition, and control the level of competition?