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
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What is a sparse index?
How many codd's rules are satisfied by teradata database?
How is MLOAD Teradata Server restarted after execution?
What are the different design perspectives used in teradata?
How does hashing happens in teradata?
Explain parsing engine in teradata?
What do you mean by parsing?
What is the use of teradata system software?
What is meant by a Highest Cost Plan?
What is the difference between union and union all in teradata?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Comment whether bottleneck is an error or not.
Why are oltp database designs not generally a good idea for a data warehouse?