What is the difference between heap table and temporary table?

1162

---

What are the advantages of myisam over innodb?

1025

---

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()?

1032

---

What is ddl, dml, and dcl?

1028

---

What is the difference between truncate and delete in mysql?

1179

---

What is blob and text in mysql?

1220

---

How to get the current date in mysql?

1112

---

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

1052

---

How do you backup a database in mysql?

1126

---

What is heap table?

1078

---

What is sql server profiler?

1062

---

What is the standby server?

1002

---

What is collation sensitivity? Explain different types.

1058

---