Bizsolindia Services Interview Questions and Answers for Freshers

Q1. Technical skills required. Some questions of programming languages are asked.
Add your answer
Q2. What are the SQL command groups?
Ans. 
SQL command groups are DDL, DML, DCL, and TCL.
• DDL (Data Definition Language) - used to define database schema and structure

• DML (Data Manipulation Language) - used to manipulate data stored in the database

• DCL (Data Control Language) - used to control access to data stored in the database

• TCL (Transaction Control Language) - used to manage transactions in the database

• Examples: CREATE, ALTER, DROP (DDL); SELECT, INSERT, UP...read more
Answered by AI
Add your answer
Q3. Explain Object Oriented Programming in Python?
Ans. 
Object Oriented Programming is a programming paradigm that uses objects to represent real-world entities.
• Python supports OOP concepts such as encapsulation, inheritance, and polymorphism.

• Classes are used to create objects, which have attributes and methods.

• Inheritance allows for the creation of subclasses that inherit properties and methods from a parent class.

• Polymorphism allows for the use of a single method or funct...read more
Answered by AI
Add your answer
Q4. VLookup, Hlookup, Pivot Table in Excel
Add your answer

You will be asked to share the screen and write the codes as asked.

Q1. Details of Kafka
Add your answer
Q2. Concurrency questions
Add your answer

Q1. Can you provide an introduction about yourself?
Add your answer
Q2. What qualifications have you obtained, and can you explain the project you completed during your engineering studies?
Ans. 
I hold a Bachelor's degree in Computer Engineering and developed a web-based project for managing student records.
• Bachelor's degree in Computer Engineering from XYZ University.

• Completed a capstone project on a web application for student record management.

• Utilized technologies like HTML, CSS, JavaScript, and Node.js.

• Implemented features such as user authentication, data visualization, and a responsive design.

• Collaborat...read more
Answered by AI
Add your answer

Q1. Why do you believe this company is a suitable fit for you?
Ans. 
This company aligns with my values, offers growth opportunities, and fosters innovation, making it an ideal environment for my skills.
• The company's commitment to innovation resonates with my passion for developing cutting-edge software solutions.

• I admire the collaborative culture here, which I experienced during my interactions with the team during the interview process.

• The emphasis on professional development and cont...read more
Answered by AI
Add your answer
Q2. Do you have any questions
Add your answer

Q1. Aap kiskey relative ya reference ho ?
Add your answer
Q2. How early you can join ?
Add your answer

Q1. About you role in previous company and domain knowledge
Add your answer
Q2. Buttering karini hogi kar sakoge ?
Add your answer

Round duration - 180 minutes
Round difficulty - Hard

The test link had 3 days expiry so I could attempt test anytime. It was conducted on doselect.com

Q1. 
Equilibrium Indices in a Sequence
You are given an array/list named 'SEQUENCE', which consists of 'N' integers. The task is to identify all equilibrium indices in this sequence.
Explanation:
An equilibr...read more
Ans. 
The task is to find the equilibrium indices of a given sequence, where the sum of elements at lower indices is equal to the sum of elements at higher indices.
• Iterate through the sequence and calculate the total sum of all elements

• Initialize a left sum and right sum as 0

• For each index, update the left sum and right sum and check if they are equal

• If they are equal, add the index to the equilibrium indices

• Return the equil...read more
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Medium

Video interview round wherein I was asked to wrote code for the problem statements given by the interviewer. The problems were mainly focused on advanced JS concepts like asynchonous progamming, timers, closures, and data structure problems around arrays, sets, linked list etc.

Q1. 
Rearrange Linked List Problem Statement
Given a singly linked list in the form 'L1' -> 'L2' -> 'L3' -> ... 'Ln', your task is to rearrange the nodes to the form 'L1' -> 'Ln' -> 'L2' -> '...read more
Ans. 
The task is to rearrange the nodes of a singly linked list in a specific order without altering the data of the nodes.
• Iterate through the linked list to find the middle node using the slow and fast pointer technique.

• Reverse the second half of the linked list.

• Merge the first and reversed second half of the linked list alternatively to get the desired order.
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

This was the last round with HR wherein they judged cultural fit and there was discussion on things like my expectations v/s their expectations etc.