BirchStreet Systems Associate Software Engineer Interview Questions and Answers

Q1. Normal core java questions
Add your answer

Q1. Normal java questions
Add your answer

Q1. Salary expectation
Add your answer

Q1. Asked about my experience as an integration developer
Add your answer

Q1. Core JavaScript related questions like closure, IIFE, functional scope, DSA, and low level system design
Add your answer

Q1. Architecture level question, more about project, message queue broker, API security
Add your answer

Q1. Work location and offer discussion
Add your answer

Q1. What are joins in sql
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer
Q2. Types of arrays in PHP
Ans. 
Types of arrays in PHP include indexed arrays, associative arrays, and multidimensional arrays.
• Indexed arrays: default type where each element is assigned a numeric index starting from 0.

• Associative arrays: elements are assigned a specific key instead of numeric index.

• Multidimensional arrays: arrays within arrays, creating a matrix-like structure.

• Example: $indexedArray = [1, 2, 3]; $associativeArray = ['key1' => 'value...read more
Answered by AI
Add your answer

Basic apptitide questions from easy topic suggestions to watch YouTube video better experience

Coding test basic programming one or two advanced programming to be performed

Covers basics aps around 15 question

DSA based questions from leetcode easy and medium

Easy to moderate question

Q1. What is Axios? What is friend function? Given any array find the multiple elements?
Ans. 
Axios is a popular JavaScript library used for making HTTP requests.
• Axios is commonly used in frontend applications to communicate with backend servers.

• It supports promises and can be used in both browser and Node.js environments.

• Example: axios.get('https://api.example.com/data')

• Friend function is a function that is not a member of a class but has access to its private and protected members.

• It is declared with the keyw...read more
Answered by AI
Add your answer