Explanation:Clustered index should be created on frequently used tables. 2. Point out the correct statement :
A. Avoid less row count SQL statements that can cause a table lock
B. A blocking lock occurs when one lock causes another process to wait in a holding queue
C. Lock is a done by database when any connection access a different piece of data concurrently
D. None of the mentioned
Answer:A
Explanation:Clustered index should be created on frequently used tables. 2. Point out the correct statement :
A. Avoid less row count SQL statements that can cause a table lock B. A blocking lock occurs when one lock causes another process to wait in a holding queue C. Lock is a done by database when any connection access a different piece of data concurrently D. None of the mentioned
Explanation:If blocking locks are common (rather than infrequent), there is probably some kind of design or query implementation problem. 3. Which of the following scenario give rise to deadlock (There are 2 processes) ?