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
- 7058 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How many memory layers are in the shared pool?
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.
wat is global index and local indes
Explain the use of table functions.
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
who owns the operating system files created by the utl_file package?
What are statistics, under what circumstances they go out of date, how do you update them?
how can you connect from 10g user to 11g user??
what are the benefits of flashback feature?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Why would you call update statistics? : sql server DBA
You have just compiled a PL/SQL package but got errors, how would you view the errors?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
