Describe concurrency control.
No Answer is Posted For this Question
Be the First to Post Answer
Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.
What the TRANSLATE('333SQD234','0123456789ABCDPQRST','0123456789') will return ?
Explain what is a deadlock and mention how it can be resolved?
What is a foreign key constraint?
What is delimiter in dbms?
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
When does checkpoint occur?
What is 3nf in dbms?
What is a checkpoint and When does it occur in database?
0 Answers TryTechnicals Pvt Ltd,
What is dbms language?
user says the db performance is slow or yesterday the query runned 1min and today its taking 30 min. how to trouble shot or were to start with?
How to lock records in a table?
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)