Oracle | Senior Application Software Engineer | 技术电面 + Onsite 面经

Initial Technical Screening

1. Find the alphabetically maximum substring from a given string.
2. Remove all even-positioned nodes from a singly linked list.

Java 基础问题：
1. Explain the String Pool.
2. Difference between String, new String(), and StringBuilder.
3. When should each be used?

SQL 题目：
Given the following tables:

• Student(Id, Name, DeptId)
• Department(Id, Name)
  

Write an SQL query to list all departments sorted by:
1. Number of students (descending)
2. If two departments have the same student count, sort them alphabetically by department name.

Technical Interview 1 (DSA + OOPs)
DSA 题目：
Given an array of movie ratings (ratings can be positive or negative), maximize the total rating collected with the constraint that you cannot skip more than one consecutive movie.

Technical Interview 2
系统设计与架构讨论：
1. SQL vs NoSQL databases
2. Why a queue was or wasn't used in the architecture
3. SLA considerations
4. Design decisions and trade-offs

DSA 题目：
Given a matrix where:
1. 1 represents a valid path
2. 0 represents a blocked cell
Find all possible paths from the top-left to the bottom-right cell. Movement is allowed only Right and Down.

Hiring Manager Round
Behavioral & System Design：
1. System design questions
2. Leadership and ownership experiences
3. Resolving conflicts within a team
4. Stakeholder communication
5. Business impact of the projects

Bar Raiser Round
Behavioral & System Design：
1. System design discussions
2. Situation-based behavioral questions
3. Decision-making scenarios (for example, how to prioritize between two critical tasks)
4. Ownership, collaboration, and handling ambiguity

lz 是在中低物价地区吗？ 我上次问recruitor他说加州暂时不招， 只有oci可能招

匿名用户 发表于 2026-08-17 17:01:37
lz 是在中低物价地区吗？ 我上次问recruitor他说加州暂时不招， 只有oci可能招

是的，中部...