SQL - What is a deadlock?

GeekInterview.com > Interview Questions > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 154 of 171

What is a deadlock?

There is a table with Pluks('plk') and Zinks ('zin'). Each Pluk only
resides on a single Zink and each Zink may contain multiple Pluks. How
do you find how many Pluks are on each and every Zink? Please provide SQL.

What is a deadlock?

Total Answers and Comments: 3

Last Update: May 16, 2008 Asked by: Namataraginu

Sponsored Links

Best Rated Answer

—

Submitted by: g_sidhu

A deadlock occurs when two or more users are waiting for data locked by each other. When this happens, these users are stuck (deadly embraced) and cannot continue processing.

Oracle automatically detects deadlocks and resolves them by rolling back one of the statements involved in the deadlock, thus releasing one set of data locked by that statement. The session that is rolled back will observe Oracle error: ORA-00060: deadlock detected while waiting for resource.

Above answer was rated as good by the following members:
singh13

February 05, 2008 03:41:37

sridevip_2008

Member Since: January 2008 Contribution: 2

RE: What is a deadlock?

Deadlock is a process it occurs when two users are trying to modify the same data at the same time then problem occurs with this process then oracle automatically locks one user so that other user can process the data.

Sridevi

Is this answer useful? Yes | No

0 2

Overall Rating: -2

February 05, 2008 23:13:29

g_sidhu

Member Since: August 2007 Contribution: 122

RE: What is a deadlock?

A deadlock occurs when two or more users are waiting for data locked by each other. When this happens these users are stuck (deadly embraced) and cannot continue processing.

Oracle automatically detects deadlocks and resolves them by rolling back one of the statements involved in the deadlock thus releasing one set of data locked by that statement. The session that is rolled back will observe Oracle error: ORA-00060: deadlock detected while waiting for resource.

Is this answer useful? Yes | No

2 0

Overall Rating: +2

May 16, 2008 04:23:27

krishnaindia2007

Member Since: September 2007 Contribution: 854

RE: What is a deadlock?

Dead lock is a unique situation in multiuser system that causes two or more users to wait indefinately for a locked resource. First user needs a resource locked by the second user and second user needs the resource locked by the first user.To avoid deadlocks avoid using exclusive locks. if using commit the data frequently to release locks.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank