Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

Explain multi-version concurrency control in MySQL?

Question Posted / amith

Answers were Sorted based on User's Feedback



Explain multi-version concurrency control in MySQL?..

Answer / cp

Multiversion concurrency control (abbreviated MCC or MVCC),
in the database field of computer science, is a concurrency
control method commonly used by database management systems
to provide concurrent access to the database.
MVCC provides each user connected to the database with a
"snapshot" of the database for that person to work with. Any
changes made will not be seen by other users of the database
until the transaction has been committed.

Is This Answer Correct ?    2 Yes 0 No

Explain multi-version concurrency control in MySQL?..

Answer / amith

Each row has two additional columns associated with it -
creation time and deletion time, but instead of storing
timestamps, MySQL stores version numbers

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows

2 Answers  

suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

0 Answers   ACC,

how to Return total number of rows.

0 Answers  

If you specify the data type as DECIMAL (5,2), what?s the range of values that can go in this table?

2 Answers  

How to create a table?

0 Answers  

Explain triggers and stored procedures?

0 Answers  

Why MySQL is used?

0 Answers  

What are the nonstandard string types?

0 Answers  

How to delete a table.

0 Answers  

What are the steps required to view your mysql database?

0 Answers  

What are the advantages of mysql?

0 Answers  

how to find missing numbers between two order numbers; and dates ?

1 Answers  

For more MySQL Interview Questions Click Here
Categories