Answer / gurmeet shah

Atomicity,Consistency,Isolation,Durability

Atomicity:
1. a transaction is a unit of operation - either all the
transaction's actions are completed or none are
2 atomicity is maintained in the presence of deadlocks.

Consistency: Consistency is the ACID property that ensures
that any changes to values in an instance are consistent
with changes to other values in the same instance

Isolations: The isolation portion of the ACID properties is
needed when there are concurrent transactions. Concurrent
transactions are transactions that occur at the same time

Durability:It refers to the ability of the system to
recover committed transaction updates if either the system
or the storage media fails.

Answer / amith

Automicity transactions are atomic and should be treated
as one in case of rollback. Consistency - the database
should be in consistent state between multiple states in
transaction.

Isolation no other queries can access the data modified by
a running transaction. Durability system crashes should not
lose the data.

How do you index just the first four bytes of the column?

2 Answers  

---

If we create a column with data type VARCHAR(3), what would we expect to see in MySQL table?

2 Answers   ABC,

---

How to write after insert event update trigger on the same table in mysql?

0 Answers  

---

How to get last inserted id after insert data from a table in mysql?

0 Answers  

---

Why is it called mysql?

0 Answers  

---

What is the phantom problem?

0 Answers  

---

What is database url for mysql?

0 Answers  

---

How to install mysql?

0 Answers  

---

How to set mysql variable in php?

0 Answers  

---

What is prepared statement in mysql?

0 Answers  

---

Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command

5 Answers   Amdocs, MediaSoft,

---

Can we store files in mysql?

0 Answers  

---