Explanation:sys.partitions contains a row for each partition of all the tables and most types of indexes in the database. 10. Which of the following best practice should be carried out concerning data types ?
A. Avoid using NOLOCK on SQL Server UPDATE and DELETE statements
B. Capturing SQL Server Deadlock Information in XML Format
C. Optimistic Locking in SQL Server using the ROWVERSION
D. Processing Data Queues in SQL Server with READPAST and UPDLOCK
Answer:A
Explanation:sys.partitions contains a row for each partition of all the tables and most types of indexes in the database. 10. Which of the following best practice should be carried out concerning data types ?
A. Avoid using NOLOCK on SQL Server UPDATE and DELETE statements B. Capturing SQL Server Deadlock Information in XML Format C. Optimistic Locking in SQL Server using the ROWVERSION D. Processing Data Queues in SQL Server with READPAST and UPDLOCK
Explanation:Implementing optimistic locking utilizing the rowversion datatype is an effective, low overhead way to prevent lost updates while still maintaining application concurrency. Sanfoundry Global Education & Learning Series – SQL Server.