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 is the use of ocr?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What purpose does the model database server? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What the different components in replication and what is their use? : 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?
What authentication modes does sql server support? : 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?
how can you communicate with operating system files from oracle?
internal architecture
What is the default fill factor value? : sql server DBA
what is the use of recording information about current session?
How would you go about verifying the network name that the local_listener is currently using?