Google SQL Developer Interview Questions and Answers

Quant and verbal related questions

Q1. All questions related to SQL and some python questions
Add your answer
Q2. Explain about VIEW in SQL
Ans. 
A VIEW in SQL is a virtual table created by a query. It does not store data itself but displays data from one or more tables.
• Views are used to simplify complex queries by storing them as a virtual table.

• They can be used to restrict access to specific columns or rows of a table.

• Views can also be used to join multiple tables and present the data in a more readable format.

• Changes made to the underlying tables are reflecte...read more
Answered by AI
Add your answer

45 minutes
arrays, strings,
SHL

Q1. Find number of nodes in a tree and it's time complexity
Ans. 
To find number of nodes in a tree, perform a depth-first or breadth-first traversal and count the nodes. Time complexity is O(n).
• Perform a depth-first or breadth-first traversal of the tree

• Count the nodes as you traverse the tree

• Time complexity is O(n) where n is the number of nodes in the tree
Answered by AI
Add your answer
Q2. What is abstraction and how do you implement it ??
Ans. 
Abstraction is the concept of hiding complex implementation details and showing only the necessary information.
• Abstraction allows developers to focus on the essential features of an object or system.

• It helps in reducing complexity and improving efficiency in software development.

• Implement abstraction in programming by using abstract classes and interfaces.

• Example: In a car, we don't need to know the internal workings o...read more
Answered by AI
Add your answer

Q1. What is the minimum number of coins to reach the target with the coins 1,2,5
Ans. 
The minimum number of coins to reach a target amount can be calculated using dynamic programming.
• Use dynamic programming to calculate the minimum number of coins needed to reach the target amount.

• Start by initializing an array to store the minimum number of coins needed for each amount from 0 to the target amount.

• Iterate through the coin denominations and update the minimum number of coins needed for each amount based
Answered by AI
Add your answer
Q2. Byte stream to human readable format without using library
Ans. 
Convert byte stream to human readable format without using library
• Iterate through the byte stream and convert each byte to its ASCII character representation

• Concatenate the ASCII characters to form the human readable format

• Handle special characters and edge cases appropriately
Answered by AI
Add your answer

Array, math, sort, string javascript qutions

Simple coding qution

Coding round was there. Two coding questions were asked to solve in 1 hour. The difficulty was easy to medium.Leetcode questions of arrays and strings.

Q1. It was an online tech interview. There were two panelists. One asked me about my projects and gave me one coding question to solve which was based on matrices. And i was supposed to explain the approach an...read more
Add your answer
Q2. After solving the question. In the same interview zoom meet HR asked me something about me and my family and thats it.
Add your answer

OnCampus Test including DSA Questions

Q1. Introduce yourself
Add your answer
Q2. DSA Question based on Dynamic Programming
Add your answer

Data structure and algorithms