Answer / Shishpal

MyISAM Static tables have a fixed table size, which means they cannot be resized once created. MyISAM Dynamic tables can be resized as needed by adding or removing rows from the data file (.MYD).

Why do we need a foreign key?

1 Answers  

---

Is sql a scripting language?

1 Answers  

---

What does select count (*) mean in sql?

1 Answers  

---

How delete all records from table in sql?

1 Answers  

---

What Is a Trigger? How Do You Use It?

3 Answers  

---

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 Answers  

---

Why coalesce is used in sql?

1 Answers  

---

How does sql*loader handles newline characters in a record? : aql loader

1 Answers  

---

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

---

Explain isolation levels. : Transact sql

1 Answers  

---

What is int identity in sql?

1 Answers  

---

What is the difference between drop and truncate commands?

1 Answers  

---