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 |
how can you find out if a table can be redefined?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What would you use to improve performance on an insert statement that places millions of rows into that table?
what are the types of connection load-balancing?
How to determine the service pack currently installed on SQL Server?
What are the ways tablespaces can be managed and how do they differ?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
Give two methods you could use to determine what DDL changes have been made.
What are the different sql server versions you have worked on? : sql server DBA
what is a user-defined lock?
what is the differnce between process and thread ?