MySQL interview questions
1. Primary key Superkey Candidate foreign key
2. Four characteristics of database transactions and their meanings
3. What does a view do? Can a view be changed?
4. Differences between DROP, DELETE, and TRUNCate
5. How indexes work and their types
6. Type of connection
7. Database paradigm
8. Database optimization ideas
9. The difference between stored procedures and triggers
Redis interview questions
1. What are the benefits of Redis?
2. What advantages does Redis have over memcached?
3. Redis common performance problems and solutions
4. There are 2000W data in MySQL, but only 20W data in REDis. How to ensure that the data in REDis is hot data
5. What are the differences between Memcache and Redis?
6. What are the common performance problems of Redis? How to solve it?
7. Redis is the most suitable scenario
8. Do you know the synchronization mechanism of Redis?
9. Have you used Redis cluster? What is the principle of cluster?
10. How does redis cluster ensure consistency?
Nginx interview questions
1. Please explain what Nginx is.
2. Please list some features of Nginx?
3. What are the differences between Nginx and Apache?
4. Explain how Nginx handles HTTP requests.
5. How can undefined server names be used to prevent requests from being processed in Nginx?
6. What are the advantages of using a reverse proxy server?
7. List the best uses of the Nginx server.
8. Please explain what are the Master and Worker processes on the Nginx server?
9. Please explain how you can start Nginx through a different port than 80.
10. Please explain if it is possible to replace Nginx error with error 502, 503?
11. In Nginx, explain how to keep double slashes in URLS.
12. Explain what ngx_HTTP_upstream_module does?
13. Please explain what the C10K problem is and how it was solved later?
14. State the function of the stub_STATUS and sub_filter directives.
15. Explain whether Nginx supports compression of requests upstream?
16. Explain how to obtain the current time in Nginx.
17. What is the purpose of interpreting -s with Nginx server?
18. Explain how to add modules to the Nginx server.
19. How can multiple work processes in nginx listen on the same port? How to handle customer connection stampedes?
20. How do hot updates to nginx programs work?
They are the interview questions
1. What is Zookeeper?
2. What does ZooKeeper offer?
3. Zookeeper file system
4. Four types of ZooKeeper ZNodes
5. Zookeeper notification mechanism
6. What are the application scenarios of ZooKeeper?
7. Zk naming service
8. Zk configuration management service
9. Cluster management of ZK
Zk distributed lock
11. Zk queue management
12. Zk data replication
13. How ZK works
14. How does ZK ensure the consistency of the order of things
15. Server status in the ZK cluster
16. How does ZK elect its Leader?
17. Zk synchronization process
18. Distributed notification and coordination
19. Session mechanism of ZK
Directing the interview questions
1. What is MongoDB?
2. What language is MongoDB written in?
3. What are MongoDB’s advantages?
4. What is a database?
5. What is a set?
What is a document?
7. Comparison chart of MongoDB and relational database terms
8. What is “Mongod”?
9. What are the “Mongod” parameters?
10. What is “Mongo”?
11. Which MongoDB command can switch databases?
12. What is a non-relational database?
13. What are the types of non-relational databases?
14. Why MOngoDB?
15. In what scenarios will MongoDB be used?
16. What do namespaces in MongoDB mean?
17. Which languages support MongoDB?
18. How do I create a new database in MongoDB?
19. How do I view the database list in MongoDB?
20. What is sharding in MongoDB?
21. How do I view connections using MongoDB?
22. What is replication?
23. How do I insert a document into a collection in MongoDB?
24. How do I remove a database in MongoDB?
25. How do I create a collection in MongoDB?
26. How do I view a created collection in MongoDB?
27. How do I delete a collection in MongoDB?
28. Why use profilers in MongoDB?
29. Does MongoDB support primary and foreign key relationships?
30. What data types does MongoDB support?
31. Why use “Code” in MongoDB?
32. Why use “Regular Expression” in MongoDB?
33. Why use the “Object ID” data type in MongoDB?
34. How do I insert a document into a collection?
35. What are the components of “ObjectID”?
36. What are indexes in MongoDb?
37. How do I add indexes?
38. What are the alternatives to MongoDB?
39. How do I query documents in a collection?
40. What method can be used to format the output?
41. How do I use “AND” OR” conditional loop to query documents in a collection?
42. How do I update data in MongoDB?
13. How do I delete a document?
44. How do I sort things in MongoDB?
45. What is aggregation?
46. What are replica sets in MongoDB?
47. Mongodb storage features and internal principles?
The last