What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
Answer Posted / 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 |
Post New Answer View All Answers
What are the different types of upgrades that can be performed in sql server? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What the different components in replication and what is their use? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
what is a user-defined lock?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
How would you best determine why your MVIEW couldn't FAST REFRESH?
which background process invoke at the time of upgradation tell me???
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Explain about your sql server dba experience? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?