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.

What is the main different between Null and NOT Null. Difference between Primary and Unique Key. How to Check the database from which application is it possibe.

6 Answers  

---

How to use regular expression in pattern match conditions?

0 Answers  

---

Does facebook still use mysql?

0 Answers  

---

What is the difference between the primary and unique key in mysql?

0 Answers  

---

What is index length in mysql?

0 Answers  

---

In mysql, what is the default storage engine?

0 Answers  

---

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .

2 Answers   Zensar,

---

What is acid in mysql?

0 Answers  

---

Please suggest me any course and institute which provide training on the below skills. • Knowledge of data extraction concepts and tools • QMF (query management facility)queries • Experience and expertise in QMF queries • Excellent ability to write, read, and interpret QMF queries against the Source Data Warehouse base level (daily and monthly) and month-end affinity comp tables • RDBMS & ER • Knowledge of Relational Databases (RDBMS) and Entity Relationship (ER) Diagrams • SOURCE Data Warehouse • Experience and expertise in Source Data Warehouse or data warehouses on the mainframe. • MS SQL Server • Experience in MS SQL Server • Excellent skill in writing/interpreting SQL queries and running Data Transformation Services (DTS) or open query packages. • Knowledge of writing/interpreting Visual Basic code.

1 Answers  

---

about join

2 Answers  

---

what do you mean by longblob Data type in MySql?

3 Answers  

---

how to know the tables in database having foreign key?

2 Answers  

---