Interested to Buy Any Domain ? << Click Here >> for more details...
write lock is compatiable with which type of lock?
- 6 Answers
- 12945 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 do you mean by tpt in teradata?
What is smp and mpp platforms?
Explain the teradata primary index mechanics in detail with a diagram.
How many types of index are present in teradata?
What is dimensional modeling?
can we join volatile table with general table an global temporary table with general table ?
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
What are the functions performed by bynet?
what is identity column in TD?
Name the five phases that come under MultiLoad Utility.
IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.
How can we load single row of data into teradata database. please give me the process.
Teradata 
