| 1. | Row - level locking is automatic 行级锁定为自动。 |
| 2. | If table locking is not used , the default uses row - level locks , unless the 如果未使用表锁定,默认使用行级锁定,除非 |
| 3. | Row - level locks used 使用行级锁定 |
| 4. | By default , row - level locking is used for data pages , and page - level locking is used for index pages 默认情况下,行级锁定用于数据页,页级锁定用于索引页。 |
| 5. | After acquiring the stronger lock , all page - and row - level locks held by the transaction on the table are released 得到更强的锁后,事务在表上所持有的所有页级及行级锁都将予以释放。 |
| 6. | Each index record contains a five - byte header that may be preceded by a variable - length header . the header is used to link together consecutive records , and also in row - level locking 每个索引记录包含一个五字节的头,在它之前还有一个变长的头。这个头是用来连接连续的记录,也用于行级锁。 |
| 7. | Derby is a 100 - percent java programming language rational database , and offers stored procedures and triggers , row - level locking , can perform transaction commits and roll - backs , and supports encryption Derby是100 %的java编程语言关系数据库,并提供了存储过程和触发器,行级锁定,可以执行事务提交和回退操作,并支持加密。 |
| 8. | If the lock escalation attempt succeeds and the full table lock is acquired , then all heap or b - tree , page page , key - range , or row - level locks held by the transaction on the heap or index are released 如果锁升级尝试成功并获取全表锁,将释放事务在堆或索引上所持有的所有堆或b树锁、页锁( page锁) 、键范围锁( key锁)或行级锁( rid锁) 。 |
| 9. | Serializability may not be implemented using only row - level locks ; there must be another mechanism that prevents a newly inserted row from becoming visible to a transaction that has already executed a query that would return the row 如果仅仅通过“行级锁”是无法实现事务序列化的,必须通过其他机制保证新插入的数据不会被刚执行查询操作的事务访问到。 |
| 10. | To support multiple applications accessing the same database at the same time , sql server mobile provides row - level locking of data pages , page - level locking , and isolation levels to help ensure data integrity during concurrency 为支持多个应用程序同时对同一数据库进行访问, sql server mobile提供了数据页行级锁定、页级锁定和隔离级别来帮助确保并发期间的数据完整性。 |