Interested to Buy Any Domain ? << Click Here >> for more details...
What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
- 1 Answers
- 7129 Views
- I also Faced
- E-Mail Answers
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 default port no on which sql server listens? : sql server DBA
what is grd?
What is the importance of a recovery model? : sql server DBA
. 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?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What is dbcc? : sql server DBA
how can you create a user-defined lock?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Why would you use sql agent? : 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.
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
internal architecture
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.
