Google Senior Associate Interview Questions and Answers

Q1. Self introduction
Add your answer

Q1. What is Pattern Matching in SQL
Ans. 
Pattern matching in SQL is a technique used to search for specific patterns within strings or data.
• Pattern matching is commonly used with the LIKE operator in SQL to search for specific patterns within text data.

• Wildcards such as % (percent sign) and _ (underscore) are used in conjunction with the LIKE operator to represent unknown characters or sequences.

• For example, 'SELECT * FROM table WHERE column LIKE 'A%'' would ...read more
Answered by AI
Add your answer
Q2. What is recursive stored procedure
Ans. 
A recursive stored procedure is a stored procedure that calls itself within its own code.
• Recursive stored procedures are used to perform repetitive tasks that require iteration.

• They can be used to traverse hierarchical data structures like trees or graphs.

• Care must be taken to prevent infinite loops by including a termination condition.

• Example: Factorial calculation using recursion in a stored procedure.
Answered by AI
Add your answer

Q1. Yourselves and experience related
Add your answer

Q1. Same mentioned above
Add your answer

Aptitude was on simple English vocabulary and basis maths

Q1. What is embedded c and how is it different from normal c
Ans. 
Embedded C is a variant of C programming language used for programming embedded systems.
• Embedded C is used for programming microcontrollers, sensors, and other embedded systems.

• It has limited resources and memory, so it requires efficient coding.

• It has specific libraries and functions for hardware control.

• Normal C is used for general-purpose programming and has no specific hardware dependencies.

• Embedded C is compiled u...read more
Answered by AI
Add your answer

Basic aptitude and technical questions

Q1. Strength weakness why you want to change job
Add your answer
Q2. Why do want work with bosch What you know about bosch
Add your answer
Q3. Nothing special, self introducing
Add your answer

Q1. Self introduction what ever you are telling be confident on it
Add your answer

Simple program on bitwise operation

Q1. Basics question on embedded c
Add your answer
Q2. What is big endian and little endian
Ans. 
Big endian and little endian are two ways of storing multibyte data types in computer memory.
• Big endian stores the most significant byte first, while little endian stores the least significant byte first.

• For example, the number 0x12345678 would be stored as 12 34 56 78 in big endian and 78 56 34 12 in little endian.

• The choice between big endian and little endian can affect data transmission and compatibility between di
Answered by AI
Add your answer