Interested to Buy Any Domain ? << Click Here >> for more details...
write lock is compatiable with which type of lock?
- 6 Answers
- 12510 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 do you mean by parsing?
Explain the term 'database' related to relational database management system?
What is the difference between global temporary tables and volatile temporary tables?
What do you mean by teradata intellicloud?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Difference between multiload and tpump?
What are the uses of client software involved in teradata?
what is sysdba and sysdbc ? which has high priority ?
In BTEQ, how are the session-mode parameters being set?
Explain the meaning of Amp?
What is meant by a node?
How to run a query in teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
