What are Heap tables?

Question Posted / kshitij kumar

1 Answers
1475 Views
I also Faced
E-Mail Answers

What are Heap tables?..

Heap tables are in-memory tables used for high-speed temporary storage. But, TEXT or BLOB fields are not allowed within them. They also do not support AUTO INCREMENT.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More MySQL Interview Questions

The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?

4 Answers Afixi, GE,

Explain Normalization concept?

2 Answers Inuva,

Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?

0 Answers

What is the maximum number of columns per table?

0 Answers

What, if a table has one column defined as TIMESTAMP?

0 Answers

What is the purpose of mysql database?

0 Answers

How do I create a mysql username and password?

0 Answers

What is flush privileges in mysql?

0 Answers

What does mysql flush tables do?