Google Engineer L4 Interview Questions and Answers

It was codility test with 2 questions

Q1. One codility question
Add your answer

Q1. Design system like uber eats
Add your answer

Q1. Design system like youtube
Add your answer

Data structure related question

Q1. Quesitions related to data structure, cloud
Add your answer
Q2. Find the second highest integer
Ans. 
To find the second highest integer in an array, sort the array in descending order and return the second element.
• Sort the array in descending order

• Return the second element in the sorted array

• Handle edge cases like duplicates or small arrays
Answered by AI
Add your answer
Q3. Question related to two sum
Add your answer
Q4. Some sliding window problems
Add your answer

Q1. General Behavioral Questions
Add your answer

It included aptitude, technical and coding questions

Q1. Questions on SQL(Joins)
Add your answer
Q2. Questions on arrays, substrings
Add your answer

Q1. Location preferred
Ans. 
Remote work preferred, open to occasional travel
• Remote work preferred

• Open to occasional travel

• Flexible with location
Answered by AI
Add your answer
Q2. Family background
Add your answer

Q1. Asked linq question and answered correctly with little modification, still was not impressed
Add your answer
Q2. Expections were little high.
Add your answer

Q1. What is the inheritance?
Ans. 
Inheritance is a mechanism in object-oriented programming where a class inherits properties and behaviors from another class.
• Allows a class to inherit attributes and methods from another class

• Promotes code reusability and reduces redundancy

• Creates a parent-child relationship between classes

• Derived class can override or extend the functionality of the base class
Answered by AI
Add your answer
Q2. What are the types of joins in mysql
Ans. 
Types of joins in MySQL include inner join, left join, right join, and full join.
• Inner join: Returns rows when there is a match in both tables.

• Left join: Returns all rows from the left table and the matched rows from the right table.

• Right join: Returns all rows from the right table and the matched rows from the left table.

• Full join: Returns rows when there is a match in one of the tables.
Answered by AI
Add your answer

Q1. How to handle multiple api's
Ans. 
Use a centralized API gateway to manage and route requests to multiple APIs efficiently.
• Implement a centralized API gateway to handle incoming requests and route them to the appropriate API based on the endpoint.

• Utilize API management tools like Apigee, Kong, or AWS API Gateway to manage and monitor multiple APIs.

• Consider implementing a caching layer to improve performance and reduce the number of requests to external
Answered by AI
Add your answer
Q2. What does strstr function do?
Ans. 
strstr function searches for a substring within a string and returns a pointer to the first occurrence of the substring.
• Used in C programming language

• Syntax: char *strstr(const char *haystack, const char *needle)

• Example: char *str = strstr("hello world", "world")
Answered by AI
Add your answer

Q1. Basic question on testing
Add your answer
Q2. Basic questions on java
Add your answer

It was medium, I was able to solve

It was a difficult one from leetcode and modified on the basis on the go, I was able to solve with some hints

It was a difficult one and from leetcode and modified during the begining. I was partially able to solve. But the the Interviewer was expecting some exact answer, which might not interest him.