Database engineers often meet with test questions

Database engineers meet frequently

Question 1: Why do group by and Order BY slow queries?

Question 2: What is the difference between DELETE, TRUNCate and DROP?

Question 3: Briefly describe the database design process.

Q4: Can I insert a record without specifying a field name?

Question 5: The difference between local and global indexes and their application.

Question 6: What is the relationship between transactions and locks?

Q7: what is your understanding of index?

Question 8: What is your understanding of the business?

Question 9: How do I set the size of network packets?

Question 10: what is your understanding of cursors? The classification of cursors?

11. Can you use COMMIT in triggers? Why?

Question 12: Archiving versus non-archiving? Why can archive mode be restored to any time?

Question 13: How can I improve log switching frequency?

SQL > select date from tb_send table (SendTime)

Field) for all records of the day? The SendTime field is datetime and contains the date and time.

Answer in the following jump link, often meet the test 21 questions in total, only list 15 questions! Need to complete the interview questions can be taken, at the same time about programming related information, projects, source code, documents, etc. Can be obtained!

The MySQL database

(Reprinted from the article)