What happens in a conflict? How do you handle that?
- 1 Answers
- 1123 Views
- I also Faced
- E-Mail Answers
Answer / Ankit Bhaskar
A conflict occurs when two or more concurrent transactions try to access, modify, or lock the same data object. To prevent inconsistencies and data corruption, Teradata employs a locking mechanism.nnThere are two types of locks in Teradata: shared (S) locks and exclusive (X) locks:n- Shared (S) locks allow multiple transactions to read the same data concurrently but prevent any transaction from writing or modifying the data.n- Exclusive (X) locks prohibit any other transaction from reading, writing, or modifying the locked data until the lock is released.nnIn case of a conflict, the transaction that requests an exclusive lock will be held in queue and executed once the conflicting lock is released. To handle conflicts more efficiently, Teradata uses intelligent locking mechanisms such as granular locking and automatic conflict resolution.
| Is This Answer Correct ? | 0 Yes | 0 No |
Difference between star and snowflake schemas?
Explain teradata utilities. What is multiload, fast load, tpump?
When tpump is used instead of multiload?
Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?
What are the multiload utility limitations?
what is referential constraints?how do you implement RI in teradata?
What are the uses of bynets in multi-node systems?
What is meant by a Least Cost Plan?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What are the functions of a Parser?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
how can we analyze the locks ?
Teradata 
