Business Labs PHP Developer Interview Questions and Answers

Q1. Sql advance questions
Add your answer
Q2. Sql advance questions complex
Add your answer

Coding and aptitude and logical reasoning three sections were there.In Coding you have 4 language to choose from and you must select 2 languages and in each language you have to solve 2 questions. It was relatively easy .

Q1. They ask you to do programming for questions. If you are a thief and you have an array of houses you cannot rob the beside houses of the house you ribbed. Maximise the loot.
Add your answer
Q2. Insert node at middle in linked list
Ans. 
To insert a node at the middle of a linked list, find the middle node and adjust pointers accordingly.
• Find the middle node using slow and fast pointers

• Insert the new node after the middle node

• Adjust pointers to link the new node correctly
Answered by AI
Add your answer
Q3. Find number of Perfect subarrays of the given array .A perfects subarray has odd value at odd place and even value at even position.
Ans. 
Count the number of perfect subarrays in an array where odd values are at odd positions and even values are at even positions.
• Iterate through the array and keep track of the count of odd and even numbers encountered so far.

• If the count of odd and even numbers at the current index matches the index itself, increment the count of perfect subarrays.

• Example: For array [2, 1, 3, 4], there are 3 perfect subarrays: [2, 1], [1
Answered by AI
Add your answer

Q1. They give you direct leetcode sums and ask to solve
Add your answer
Q2. Find if a number is there in a sorted array or not and if its not there where shoud it be inserted in log(n) time
Ans. 
Binary search can be used to find the number in a sorted array in log(n) time.
• Implement binary search algorithm to find the number in the sorted array.

• If the number is not found, return the index where it should be inserted.

• Time complexity of binary search is O(log n).
Answered by AI
View 1 more amswer
Q3. You are given parallel bars selecting two bars you can make a container .Maximise area.Find the slution in o(n)
Ans. 
To maximize the area of a container formed by two parallel bars, use the two-pointer approach in O(n) time complexity.
• Use the two-pointer approach to iterate from both ends towards the center of the array.

• Calculate the area formed by the two bars at each step and update the maximum area found so far.

• Move the pointer with the smaller height towards the center to potentially find a larger area.

• Repeat the process until th
Answered by AI
View 1 more amswer

Three long paragraph questions related to logical thinking take around 20-25 min to solve.

Three coding questions on array, square matrix and monster game.

Q1. Asks to introduce yourself
Add your answer
Q2. Regarding your interests in IT field and skills
Add your answer

Q1. Why do we use database
Ans. 
Databases are used to store, organize, and retrieve data efficiently for various applications.
• Efficient data storage and retrieval

• Data organization and management

• Data security and integrity

• Support for concurrent access and transactions

• Scalability and performance optimization
Answered by AI
Add your answer
Q2. What are SQL joins
Ans. 
SQL joins 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 in a single query

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

• Joins are based on a related column between the tables, such as a primary key and foreign key relationship
Answered by AI
Add your answer

Q1. What is your past experiences
Add your answer
Q2. Have web development experience
Ans. 
Yes, I have 5 years of web development experience.
• I have worked on front-end technologies such as HTML, CSS, and JavaScript.

• I am proficient in using frameworks like React and Angular.

• I have experience with back-end technologies like Node.js and databases like MySQL.

• I have developed responsive and user-friendly websites for various clients.

• I am familiar with version control systems like Git.
Answered by AI
Add your answer

Q1. Questions based on javascript, html, css .it will be based on what role you are applying for
Add your answer
Q2. Css flexbox, box model, html doctype, semantic tags javascript asynchronous , localstorage etc
Add your answer

Q1. Javascript basic question, output based question, question related to setTimeout, questions related to Currying, promises
Add your answer
Q2. React basics to advanced,custom hooks,high order components,react life cycle, why react , virtual Dom , situation based question on react . How to pass data between components,redux flow
Add your answer

Q1. Todolist implementation
Ans. 
Todolist implementation
• Create a UI for adding tasks

• Implement functionality to add, delete and mark tasks as complete

• Store tasks in a database or local storage

• Allow filtering of tasks by status (completed, active)

• Add option to edit task details
Answered by AI
Add your answer

There were 3 coding questions in the first round

30 MCQ questions based on Math, reasoning and English and also email writing

Q1. I'm on it my interview scheduled on 14 oct
Add your answer