Interested to Buy Any Domain ? << Click Here >> for more details...
write lock is compatiable with which type of lock?
- 6 Answers
- 12792 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What type of indexing mechanism do we need to use for a typical data warehouse?
Comment whether bottleneck is an error or not.
Steps to create a data model?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What is the difference between fastload and multiload?
How to find duplicates in a table?
Describe primary index in teradata. And what are the available primary index types?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What are the steps involved in the process flow of the sql statement through channel attached system?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What are the different table types that are supported by teradata?
What are the different softwares used with their functions in teradata?
How to Extract data from multiple legacy systems?
