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.

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

Which one of the following is the correct way to select all columns and all rows from "vtable"? Choice 1 SELECT FROM vtable SELF JOIN vtable Choice 2 SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = * Choice 3 SELECT EVERYTHING FROM vtable Choice 4 SELECT vtable.* WHERE vtable = vtable Choice 5 SELECT * FROM vtable WHERE 1 = 1

3 Answers  

---

How do I view mysql logs?

0 Answers  

---

HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

0 Answers  

---

How to use mysqldump to create a copy of the database?

0 Answers  

---

i made a table in sql server 2000 and in a column i want to add image path of a picture present in my hardisk... so using insert statement how will i insert the path of the image in the table??

1 Answers   WebTech,

---

---

What is the command line end user interface - mysql?

0 Answers  

---

how we will Show selected records sorted in an ascending (asc) or descending (desc).

0 Answers  

---

how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...

0 Answers  

---

What is ntext?

0 Answers  

---

Explain MySQL optimization?

1 Answers  

---

What does mysql workbench do?

0 Answers  

---

What is difference between microsoft sql and mysql?

0 Answers  

---