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 |
What are the commands used in dcl? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
What are the recovery models for a database? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
When creating a user, what permissions must you grant to allow them to connect to the database?
What are the different types of indexes available in sql server? : sql server DBA
I lost one datafile i dont have backup how can you recover that???
what are the differences of where and if in SAS?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is dbcc? : sql server DBA
why do we give pctfree and pctused in create table statement?
When a user process fails, what background process cleans up after it?
Oracle (3253)
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)