ElectrifAi Senior Software Developer Interview Questions and Answers

Q1. Basic Technical Interview
Add your answer
Q2. Basics on Framework used
Add your answer
Q3. Infrastructure related
Add your answer
Q4. Process and security
Add your answer

Q1. Salary expectations and negotiation
Add your answer

Q1. More than technology,a senior recruiter asks where you stay which gali you stay,which temple is near by,what your husband do,getting into more personal and final he will ask your janam kundali and tell you...read more
Add your answer

Q1. Senior recruiter will ask more personal questions
Add your answer

Strong appitude knowledge is required.

Q1. String , arrays, oops
Add your answer

Q1. Strecture of sql statement
Ans. 
SQL statements are used to interact with databases by performing operations like querying, updating, and deleting data.
• SQL statements are made up of keywords like SELECT, INSERT, UPDATE, DELETE, etc.

• They are structured in a specific order, with clauses like WHERE, ORDER BY, GROUP BY, etc.

• Tables are referenced using their names, and conditions are specified to filter data.

• Joins can be used to combine data from multiple
Answered by AI
Add your answer

Quantitative Aptitude

Stakeholders vs Shareholders

Analysis of financial time series

Q1. Oops interview,you have add new technology to advantage.
Add your answer

Q1. What are oops concepts, What are java8 features, functional interface, spring boot annotations, microservice.
Ans. 
Answering questions related to OOPs concepts, Java8 features, functional interface, Spring Boot annotations, and microservices.
• OOPs concepts include encapsulation, inheritance, abstraction, and polymorphism.

• Java8 features include lambda expressions, streams, default methods, and functional interfaces.

• Functional interface is an interface with only one abstract method and can be used with lambda expressions.

• Spring Boot a...read more
Answered by AI
Add your answer
Q2. Threads concepts, synchronization,
Add your answer

Q1. Basic mathematics question, basic English and SQL questions
Add your answer

Q1. Resume based questions
Add your answer
Q2. Different types of commands
Ans. 
Different types of commands include data manipulation, data definition, data control, and transaction control commands.
• Data manipulation commands: SELECT, INSERT, UPDATE, DELETE

• Data definition commands: CREATE, ALTER, DROP

• Data control commands: GRANT, REVOKE

• Transaction control commands: COMMIT, ROLLBACK, SAVEPOINT
Answered by AI
Add your answer
Q3. Difference between inner join and outer join
Ans. 
Inner join returns only the matching rows between two tables, while outer join returns all rows from both tables.
• Inner join only includes rows that have matching values in both tables

• Outer join includes all rows from both tables, filling in missing values with NULL if there is no match

• Examples: Inner join - SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id; Outer join - SELECT * FROM table1 LEFT OUTER JOI
Answered by AI
Add your answer
Q4. Write SQL query to get second highest salary
Ans. 
SQL query to retrieve the second highest salary from a table
• Use the ORDER BY clause to sort salaries in descending order

• Use the LIMIT clause to retrieve the second row
Answered by AI
Add your answer
Q5. What's the difference between numpy and pandas
Ans. 
Numpy is a library for numerical operations in Python, while Pandas is used for data manipulation and analysis.
• Numpy is used for numerical operations like linear algebra, Fourier transform, etc.

• Pandas is used for data manipulation tasks like data cleaning, merging, reshaping, etc.

• Numpy works with arrays, while Pandas works with dataframes.

• Numpy is more efficient for numerical computations, while Pandas is more user-fri...read more
Answered by AI
Add your answer