what is transaction state, buffer management, shadow paging
Answer / Mohd Kasim Khan
1. Transaction State: In databases, a transaction can be in various states such as Active, Committed, or Aborted. These states indicate the status of a transaction within the database system.
2. Buffer Management: This is a technique used to manage data stored temporarily in main memory before being written to a secondary storage device like a hard disk. The goal is to minimize the number of disk accesses to improve performance.
3. Shadow Paging: Shadow paging, also known as Copy-on-Write (CoW) paging, is an optimization technique used in virtual memory systems. When a process modifies a page, instead of writing it immediately to disk, a 'shadow' or copy of the original page is created until the modified page is actually needed.
| Is This Answer Correct ? | 0 Yes | 0 No |
There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?
Explain database partitioning.
What is the Difference Primary key and Unique Key
What is a database connection string?
Can we use redis as database?
How do I manually create a database?
Explain transaction manager?
What is the difference between oracle and MS Access?
When should you not use firebase?
Which database does facebook use?
How to do Data integrity testing? Who does this testing (Developer or tester)?
how node connect with cpu?
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)