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
How to start SQL Server in minimal configuration mode?
what is the use of recording information about current session?
internal architecture
what is ora 24313?what is the procedure to exclude that error?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
how can you communicate with operating system files from oracle?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how does an oracle clusterware manage crs resources?
How would you extract DDL of a table without using a GUI tool?
how can you enable flashback feature?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA