Explain how RDBMS software deals with deadlocks.
Answer / j.nagaraju
RDBMS has a special mechanisiam , locks , using locks we
are fightining aganist deadlockig.
| Is This Answer Correct ? | 2 Yes | 3 No |
Differentiate between nested loop, hash loop and merge join.
What is meant by database management system?
Explain a checkpoint and when does it occur?
What are indexes? Mention the differences between the clustered and non-clustered index?
How does a database store data?
What are the SQL clauses supported in the link property sheet ?
Are Constraints exported through Export command?
Explain the Surrogate Key in DBMS.
Is it possible to modify a Datatype of a column when column contains values?
Can you explain insert, update and delete query?
What is data types in database?
What are the types of database lock?
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)