Interested to Buy Any Domain ? << Click Here >> for more details...
write lock is compatiable with which type of lock?
- 6 Answers
- 12716 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
Adding to above, teradata locks objects on first come first
serve basis. write locks are generally used for dmls like
insert,update,delete. select statement uses access lock.
exclusive locks are used for ddls like create,alter. Pseudo
lock is a concept by which teradata assigns one amp to take
care of locking the rows of the table in other amps. This
amp makes sure that other amps lock the table.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between global temporary tables and volatile temporary tables?
What is the meaning of Caching in Teradata?
What are the things to be considered while creating secondary index?
What do you mean by parsing?
Where is teradata rdbms used?
Can you connect multiload from ab initio?
What is the purpose of indexes?
What is real time and near real time data warehousing?
What is the difference between teradata and basic rdbms?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What are the design features involved in teradata?
Highlight the need for Performance Tuning.
What are the uses of bynets in multi-node systems?
How to run a query in teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
