What is the difference between a clustered index and a non-clustered index?
A. Clustered index determines the physical order of data; non-clustered does not
B. They are the same
C. Clustered index is faster for inserts
D. Non-clustered index determines physical order; clustered does not
Answer: Option A
Solution (By JKSSB Mock Tests)
A clustered index sorts and stores the data rows in the table based on key values, while a non-clustered index is a separate structure that points to the data rows.
What is the situation called when two or more transactions are permanently blocked, each waiting for a lock held by the other transaction to be released?
Explanation:
A Deadlock occurs when two or more transactions are stuck in a circular dependency, each waiting for resources locked by the other, preventing progress.
No comments yet. Be the first to start the discussion!