Jigou Technology Interview Experience - First Interview

May 27, 2023#面试118

AI Translation

This post is translated from Chinese into English through AI.View Original

AI-generated summary

The interview for a DevOps developer position in May 2023 lasted 52 minutes and focused on open-ended questions rather than standard interview scripts. Key topics included: - Challenges faced during project work, particularly in database migration and comparisons between MySQL and PostgreSQL, as well as considerations for other databases. - Discussion on database scalability, including vertical vs. horizontal scaling, and how to ensure data consistency after expansion. - Familiarity with open-source components in the Java community, understanding of object-oriented vs. procedural programming, and the core logic of Spring AOP and dependency injection. - A logic problem involving the number of employees skilled in different programming languages and an algorithm question about finding the k-th largest element in an unsorted array, including time and space complexity considerations.

This interview did not ask too many standard questions, but rather some divergent questions.

Position: DevOps Developer
Time: May 2023
Interview Duration: 52 minutes

Project#

Talk about a challenging area where you gained a lot of insights.
- Besides MySQL and PostgresSQL databases, have you considered and compared other databases in the database migration aspect?
- What are the aspects of database comparison (besides performance, have you considered whether future data growth might cause bottlenecks)? How did you make decisions and considerations on different points? Can you elaborate?
- How does the scalability of containers compare to physical servers?
- What are vertical and horizontal scaling in databases?
- How is horizontal scaling achieved in MySQL and PostgresSQL databases, and what are the differences between them?
- How is data consistency ensured after database scaling (discuss commonly used methods in the industry)?

Java#

Which open-source components are you familiar with in the Java community? Share your understanding.
Explain your understanding of object-oriented and procedural programming.
The implementation logic of Spring AOP aspects.
What is the core logic of Spring dependency injection and the benefits it brings?

Logic Question#

In a company of 100 people, 75 know C++, 90 know Java, and 60 know Go. What is the maximum and minimum number of people who know all three languages?

Algorithm Question#

Inquire about the time and space complexity of the implementation.