write lock is compatiable with which type of lock?

Categories >> Software >> Data Warehouse >> Teradata
Suggest New Category

Question Posted / anileie

6 Answers
13072 Views
Infosys, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write lock is compatiable with which type of lock?..

Answer / yuvaevergreen

EXCLUSIVE LOCK - NONE
WRITE LOCK - ACCESS
READ - READ, ACCESS
ACCESS - READ,WRITE,ACCESS

Is This Answer Correct ?

8 Yes

0 No

write lock is compatiable with which type of lock?..

Answer / anileie

Access lock

Is This Answer Correct ?

6 Yes

0 No

write lock is compatiable with which type of lock?..

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

write lock is compatiable with which type of lock?..

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

write lock is compatiable with which type of lock?..

Answer / etlguy

exclusive lock - none.
write lock - access lock
read - read,access
access - write,read,access

Is This Answer Correct ?

1 Yes

0 No

write lock is compatiable with which type of lock?..

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

Post New Answer