Answer / subrat

MyISAM: This is default. Based on Indexed Sequntial Access
Method. The above SQL will create a MyISA table.
ISAM : same
HEAP : Fast data access, but will loose data if there is a
crash. Cannot have BLOB, TEXT & AUTO INCRIMENT fields
BDB : Supports Transactions using COMMIT & ROLLBACK. Slower
that others.
InoDB : same as BDB

Answer / sankar

its not inoDB is InnoDB

Answer / rajesh kumar

BDB supports transaction and page level locking. InnoDB
Supports Foreign Keys, Row level locking & transaction .

How to Join tables on common columns.

0 Answers  

---

How can I create database in mysql?

0 Answers  

---

In mysql, what is joins? Explain

0 Answers  

---

What is difference b/w composit key n primary key and forigion key?

4 Answers  

---

How many tables will create when we create table, what are they?

2 Answers  

---

How many columns can a mysql table have?

0 Answers  

---

How to use sum function in where clause in mysql?

0 Answers  

---

How set mysql root password?

0 Answers  

---

What are the different types of triggers in mysql?

0 Answers  

---

How to calculate expressions with sql statements?

0 Answers  

---

Explain MySQL architecture?

1 Answers  

---

Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

0 Answers  

---