What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
Answer / monal
Live Lock occurs when exclusive lock is denied continuously
by series of overlapping shared locks keep on interfering
each other and they keep changing status further preventing
them to complete the task.
Is This Answer Correct ? | 2 Yes | 1 No |
what is the role of dip user in our database?
What authentication modes does sql server support? : sql server DBA
CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva
what is the difference between db2start command and start database manager command?
What is the difference between clustered and non-clustered index? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How do you trace the traffic hitting a sql server? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
Compare and contrast TRUNCATE and DELETE for a table.
How would you determine who has added a row to a table?
what is meant by gateway