If table have access lock.In the same table write lock is
posible or not?
Answer Posted / yuvaevergreen
yes...its possible...when access lock is present in a table, write lock can be inteded for the the same table.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
Why managing the data is important?
Differentiate primary key and partition key?
What are the design features involved in teradata?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
How do you set the session mode parameters in bteq?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Highlight the advantages of PPI(Partition Primary Index).
What are the various indexes in teradata? Why are they preferred?
How you will check the version of teradata?
What is the use of virtual processor connectivity in teradata?
List out all forms of LOCKS that are available in Teradata.
How to find duplicates in a table?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you