What is the difference between heap table and temporary table?

1162

---

What are the advantages of myisam over innodb?

1026

---

How to change a password for an existing user via mysqladmin?

1028

---

What are the security alerts while using mysql?

1079

---

What is the use of mysql_close()?

1034

---

What is ddl, dml, and dcl?

1030

---

What is the difference between truncate and delete in mysql?

1181

---

What is blob and text in mysql?

1224

---

How to get the current date in mysql?

1112

---

How to display nth highest salary from a table in a mysql query?

1053

---

How do you backup a database in mysql?

1129

---

What is heap table?

1078

---

What is sql server profiler?

1063

---

What is the standby server?

1003

---

What is collation sensitivity? Explain different types.

1058

---