What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
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 does Oracle guarantee data integrity of data changes?
What are statistics, under what circumstances they go out of date, how do you update them?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How would you begin to troubleshoot an ORA-3113 error?
How can you gather statistics on a table?
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.
the process of adding a cpu in sql server is called..?
What is transparent data encryption? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
How many memory layers are in the shared pool?
what is logical system in sap basis
what is grd?
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)