write lock is compatiable with which type of lock?
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 are different table types used in teradata?
what are the day to day activities of teradata DBA ?
How to identify ppi columns?
What are the main components of teradata system?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Describe primary index in teradata?
What is meant by a Parsing Engine?
If a Node is busy what are the steps you can take to avoid ?
How to find duplicates in a table?
What is upsert statement in teradata?
why use references rather than pointers in the public api, particularly for arguments which are modified?
Did you write stored procedures in teradata?
What is the meaning of Caching in Teradata?
Define views in teradata with syntax.
What is the particular designated level at which a LOCK is liable to be applied in Teradata?