Interested to Buy Any Domain ? << Click Here >> for more details...
write lock is compatiable with which type of lock?
- 6 Answers
- 12514 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 real time and near real time data warehousing?
What do you mean by teradata intelliflex?
Difference between multiload and tpump?
What is meant by a Least Cost Plan?
What is TPD?
If RDBMS is halted what will you do ?
What is the use of having index on table?
What is spool space?
List out all forms of LOCKS that are available in Teradata.
what is meant by Hot amp?
Where we use PPI in real time??? What is the disadvantages of PPI?
Is multi insert ansi standard?
Teradata 
