GE Senior Software Engineer Interview Questions and Answers

Q1. Find the second highest salary in sql
Ans. 
Use SQL query with ORDER BY and LIMIT to find the second highest salary.
• Use SELECT statement to retrieve salary column from the table.

• Use ORDER BY clause to sort the salaries in descending order.

• Use LIMIT 1,1 to get the second highest salary.
Answered by AI
Add your answer
Q2. Check duplicate rows using sql, group by, window function.
Ans. 
Use SQL query with GROUP BY and window function to check for duplicate rows.
• Use GROUP BY to group rows with same values together

• Use COUNT() function to count the number of occurrences of each group

• Use window function like ROW_NUMBER() to assign a unique number to each row within a group
Answered by AI
Add your answer

Q1. Angular questions
Add your answer
Q2. In depth of the angular version architecture
Add your answer

Basic c Programming and Embedded Systems

Q1. C and Do-178b questions
Add your answer

Q1. C and Embedded system and Project related
Add your answer

Q1. Manager Round, Mostly technical
Add your answer

Q1. Package discussion and my previous employer details
Add your answer

Basic leetcode problems

Q1. Basic java questions
Add your answer

Q1. About project experience
Add your answer

Q1. Differentiate between RISC and CISC
Ans. 
RISC stands for Reduced Instruction Set Computing and CISC stands for Complex Instruction Set Computing.
• RISC processors have a smaller set of simple instructions, while CISC processors have a larger set of complex instructions.

• RISC processors typically execute instructions in one clock cycle, while CISC processors may require multiple clock cycles.

• RISC processors rely on optimizing compilers for performance, while CISC...read more
Answered by AI
Add your answer
Q2. Define and differentiate interpreter and compiler
Ans. 
Interpreter translates code line by line while compiler translates entire code at once.
• Interpreter: translates code line by line, slower execution, easier debugging (e.g. Python)

• Compiler: translates entire code at once, faster execution, harder debugging (e.g. C++)
Answered by AI
Add your answer