Point Out The Wrong Statement #825
Point out the wrong statement.
This multiple choice question (MCQ) is related to the book/course
gs gs116 Microsoft SQL Server.
It can also be found in
gs gs116 Performance Tuning and Optimization - SQL Server Locking - Quiz No.1.
Point out the wrong statement.
Schema modification (Sch-M) locks are used when a table data definition language operation is being performed
By default, SQL Server transactions times out after a certain time
Disallowing a locking level can affect concurrency adversely
Table-level locking hints can be used when a finer control of the types of locks acquired on an object is required
Similar question(s) are as followings:
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
