Interested to Buy Any Domain ? << Click Here >> for more details...
write lock is compatiable with which type of lock?
- 6 Answers
- 12725 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 a sparse index?
There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What are the frequently used data types in teradata?
what happen if a query fail in dispatcher?
Why does varchar occupy 2 extra bytes?
Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.
What happens when a node suffers a downfall?
What is inner join and outer join?
whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?
Describe the between keyword in teradata?
What is teradata?
Teradata 
