Interested to Buy Any Domain ? << Click Here >> for more details...
write lock is compatiable with which type of lock?
- 6 Answers
- 12802 Views
- Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
EXCLUSIVE LOCK - NONE
WRITE LOCK - ACCESS
READ - READ, ACCESS
ACCESS - READ,WRITE,ACCESS
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / 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 |
Answer / tdguy
exclusive lock - not compatible with other locks.
write lock - compatible with access lock
read - compatible with read,access
access - compatible with write,read,access
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / etlguy
exclusive lock - none.
write lock - access lock
read - read,access
access - write,read,access
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shaik mahamad rafi
write lock applying on table level ,we don't have read and exclusive .... both are in queue .
| Is This Answer Correct ? | 0 Yes | 0 No |
What is database exceptions in teradata?
What are tpump utility limitations?
Explain the term 'foreign key' related to relational database management system?
What is a level of granularity of a fact table?
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
What do you mean by caching in teradata?
Can we collect statistics on table level?
If a Node is busy what are the steps you can take to avoid ?
Highlight all the modes that are present under Confidence Level.
How do you determine the number of sessions?
What is the Maximum number of volatile tables that can be created?
Teradata 
