Bharti Airtel
300+ Chandigarh University Interview Questions and Answers
Q301. Previous working experiance explanations required
I have 5 years of experience as a Network Support Engineer.
Worked with a team to troubleshoot and resolve network issues
Configured and maintained network devices such as routers and switches
Provided technical support to end-users
Implemented network security measures
Performed network monitoring and performance analysis
Q302. What's Fiber types
Fiber types refer to the different types of optical fibers used in telecommunications.
There are two main types of fiber: single-mode and multi-mode
Single-mode fiber has a smaller core and is used for long-distance communication
Multi-mode fiber has a larger core and is used for shorter distances
Other types of fiber include polarization-maintaining fiber and dispersion-shifted fiber
Fiber types can affect the speed and quality of data transmission
Q303. What is your study
I have a Bachelor's degree in Business Administration with a focus on sales and marketing.
Studied Business Administration with a focus on sales and marketing
Completed Bachelor's degree
Took courses in sales strategies and market analysis
Q304. WHAT IS DNS ?
DNS stands for Domain Name System. It is a system that translates domain names into IP addresses.
DNS is like a phonebook for the internet
It helps to locate websites by translating domain names into IP addresses
DNS servers store information about domain names and their corresponding IP addresses
DNS can also be used for email routing and other internet services
Q305. Definition of marketing
Marketing is the process of promoting and selling products or services to customers.
Marketing involves identifying customer needs and wants.
It includes creating and communicating value propositions.
Marketing strategies can include advertising, public relations, and social media campaigns.
Market research helps in understanding customer preferences and competition.
Examples of marketing activities include product launches and brand promotions.
Q306. Market experience
I have 5 years of experience in the sales industry, specializing in the technology sector.
5 years of sales experience
Specialization in the technology sector
Proven track record of meeting and exceeding sales targets
Strong understanding of market trends and customer needs
Experience in building and maintaining client relationships
Q307. What is technical expectations
Technical expectations refer to the specific skills, knowledge, and experience required for a particular technical role.
Understanding of storage technologies such as SAN, NAS, and object storage
Proficiency in storage management tools like NetApp, EMC, or Dell EMC
Ability to troubleshoot storage performance issues
Knowledge of data protection and disaster recovery strategies
Experience with virtualization technologies like VMware or Hyper-V
Q308. How many company power
The company has multiple sources of power, including financial, human resources, technology, etc.
Company power can come from financial stability and resources.
Human resources, including skilled employees and strong leadership, contribute to company power.
Technological advancements and innovation can also be a source of power for a company.
Q309. Have you install Experience
Yes, I have installation experience in various fields such as telecommunications, IT, and construction.
Installed telecommunications equipment such as routers and switches
Set up IT systems including servers and software applications
Installed construction materials like HVAC systems and electrical wiring
Q310. Benefits of organisation
Organizational benefits include improved efficiency, increased productivity, better communication, and enhanced teamwork.
Improved efficiency through streamlined processes and workflows
Increased productivity due to clear goals and effective resource allocation
Better communication among team members and stakeholders
Enhanced teamwork leading to successful project outcomes
Opportunities for professional growth and development
Positive work culture and employee satisfaction
Q311. What is optical fibre
Optical fibre is a thin, flexible, transparent fibre made of glass or plastic that transmits light signals over long distances.
Optical fibre is used for high-speed data transmission and telecommunications.
It works by transmitting light signals through the fibre, which bounce off the walls of the fibre and travel to the other end.
Optical fibre is more efficient than traditional copper wire, as it can transmit data over longer distances without losing signal strength.
It is also...read more
Q312. Phases of project life cycle.
The phases of project life cycle include initiation, planning, execution, monitoring and controlling, and closing.
Initiation: Define the project at a broad level and obtain approval to start.
Planning: Develop a roadmap for how the project will be executed, monitored, and controlled.
Execution: Implement the project plan.
Monitoring and Controlling: Track, review, and regulate the progress and performance of the project.
Closing: Finalize all activities to formally close the proj...read more
Q313. Fiver year experience in airtel
I do not have five years of experience in Airtel.
Q314. difference between waterfall and agile
Waterfall is a linear sequential approach to software development, while Agile is an iterative and flexible approach.
Waterfall follows a sequential process with distinct phases like requirements, design, implementation, testing, and maintenance.
Agile involves breaking the project into smaller iterations called sprints, allowing for flexibility and adaptability.
Waterfall requires detailed upfront planning and documentation, while Agile focuses on collaboration and responding t...read more
Q315. DIFFERENCE BETWEEN B2B AND B2C
B2B is business-to-business sales, while B2C is business-to-consumer sales.
B2B sales involve selling products or services to other businesses, while B2C sales involve selling products or services directly to consumers.
B2B sales typically involve longer sales cycles and higher order values, while B2C sales are often more transactional and have lower order values.
B2B sales often require more personalized and consultative selling, while B2C sales may rely more on marketing and a...read more
Q316. Design BookMyShow HLD and LLD
Design high-level and low-level architecture for BookMyShow
HLD should include components like user interface, booking engine, payment gateway, etc.
LLD should detail the classes, methods, and interactions within each component
Use technologies like Java, Spring Boot, MySQL for backend and React for frontend
Consider scalability, fault tolerance, and security in the design
Q317. Routing in configuration
Routing in configuration is the process of setting up and managing the paths that network traffic takes.
Routing protocols like OSPF and EIGRP are used to determine the best path for network traffic.
Static routes can also be configured manually.
Routing tables are used to store information about network paths.
Default routes can be used to send traffic to a specific destination if no other route is available.
Routing can be configured on routers, switches, and other network devic...read more
Q318. Working of Distribution model
Distribution model involves the process of getting products from manufacturer to end customers through various channels.
Distribution model determines how products are delivered to customers
It includes channels such as wholesalers, retailers, and online platforms
Efficient distribution model ensures timely delivery and customer satisfaction
Examples: direct sales, retail distribution, online marketplace
Distribution model can impact pricing, availability, and customer reach
Q319. What is interface.
An interface is a point of interaction between two components, devices, or systems.
Interfaces define how different components communicate with each other
They can be physical (e.g. USB port) or virtual (e.g. API)
Examples include Ethernet ports, HDMI connectors, and software APIs
Q320. What major roles play vkyc
Q321. Fiber cutting angle
Fiber cutting angle refers to the angle at which a fiber optic cable is cut.
The cutting angle of a fiber optic cable is crucial for minimizing signal loss and ensuring efficient transmission.
A precise cutting angle is typically around 90 degrees to the fiber axis.
Improper cutting angles can lead to increased signal loss and poor performance of the fiber optic system.
Q322. Router technique
Router technique refers to the method used by a router to determine the best path for forwarding data packets.
Routing protocols like OSPF, EIGRP, and BGP are used to determine the best path for data packets
Static routing involves manually configuring the routes on the router
Dynamic routing allows routers to communicate with each other to determine the best path
Packet switching is used by routers to forward data packets based on destination IP address
Q323. Calculation about ROI
ROI is a financial metric used to evaluate the efficiency or profitability of an investment.
ROI is calculated by dividing the net profit of an investment by the initial cost of the investment and expressing it as a percentage.
Formula: ROI = (Net Profit / Cost of Investment) * 100
For example, if an investment of $10,000 generates a net profit of $2,000, the ROI would be 20%.
Q324. Promise polyfill from scratch
Creating a Promise polyfill from scratch involves implementing the Promise API using callbacks and handling asynchronous operations.
Understand the Promise API and its methods (resolve, reject, then, catch)
Implement a constructor function that takes an executor function as an argument
Handle asynchronous operations using callbacks and setTimeout
Implement the then and catch methods to handle success and error cases respectively
Q325. Oops concepts in java
Oops concepts in Java refer to Object-Oriented Programming principles like Inheritance, Polymorphism, Encapsulation, and Abstraction.
Inheritance: Allows a class to inherit properties and behavior from another class.
Polymorphism: Ability of an object to take on many forms.
Encapsulation: Bundling of data with the methods that operate on that data.
Abstraction: Hiding the implementation details and showing only the necessary features of an object.
Q326. Design parking lot type system.
Q327. Explained BCG Matrix
BCG Matrix is a strategic tool used to analyze a company's product portfolio based on market growth rate and relative market share.
BCG Matrix stands for Boston Consulting Group Matrix
It categorizes a company's products into four categories: Stars, Cash Cows, Question Marks, and Dogs
Stars have high market share and high growth rate, Cash Cows have high market share and low growth rate, Question Marks have low market share and high growth rate, and Dogs have low market share an...read more
Q328. Top 3 quality
Top 3 qualities are leadership, adaptability, and communication.
Leadership: ability to guide and motivate a team towards a common goal
Adaptability: willingness to adjust to changing circumstances and learn new skills
Communication: ability to convey ideas clearly and listen actively
Q329. What is core fiber
Core fiber is the central part of an optical fiber that carries the majority of the light signals.
Core fiber is the innermost part of an optical fiber
It is where the light signals travel through
Core fiber is usually made of glass or plastic
The core is surrounded by cladding to maintain the light signals within the core
Q330. What is wave lenth
Wave length is the distance between two consecutive points of a wave that are in phase.
Wave length is typically denoted by the symbol λ.
It is measured in meters or other units of length.
In electromagnetic waves, wavelength determines the color of light. For example, red light has a longer wavelength than blue light.
Q331. how many osi layer
There are 7 OSI layers in the OSI model.
There are 7 layers in the OSI model: Physical, Data Link, Network, Transport, Session, Presentation, and Application.
Each layer has specific functions and protocols associated with it.
The OSI model helps in understanding how different networking components communicate with each other.
Q332. what is ur name
My name is John Doe.
Full name is John Doe
Common name in English-speaking countries
Used as a placeholder name
Q333. Custom Reduce method of JS
Custom reduce method in JavaScript allows for custom logic to be applied when reducing an array.
Custom reduce method can be implemented using a for loop to iterate over the array elements.
The custom logic can be defined within the reduce method to perform specific operations on each element.
The initial value for the accumulator can be provided as an argument to the custom reduce method.
Example: Implementing a custom reduce method to calculate the sum of all elements in an arr...read more
Q334. Optical fibre in customer
Optical fibre in customer premises is used to provide high-speed internet and other communication services.
Optical fibre is used to deliver high-speed internet, TV, and phone services to customers' homes or businesses.
Fibre optic cables are installed inside the customer premises to connect to the network provider's infrastructure.
Customers can enjoy faster internet speeds, better video quality, and more reliable connections with optical fibre technology.
Q335. Plans and products in Airtel
Airtel offers a variety of plans and products to cater to different customer needs and preferences.
Airtel offers prepaid and postpaid plans with different data, calling, and SMS benefits.
They also have special plans for international roaming, data packs, and family plans.
Airtel provides a range of products including smartphones, broadband services, DTH services, and digital wallets.
They have partnerships with various content providers for streaming services like Airtel Xstrea...read more
Q336. Run vs CMD vs ENTRYPOINT.
Run vs CMD vs ENTRYPOINT are Docker instructions used to specify commands to be executed when a container is launched.
RUN is used to execute commands during the build of the image
CMD is used to provide default arguments for the entrypoint or to specify the command to run when the container starts
ENTRYPOINT is used to specify the executable that will run when the container starts, and CMD can be used to provide additional arguments to the entrypoint
Example: RUN apt-get update ...read more
Q337. Explain DWDM principles..?
DWDM stands for Dense Wavelength Division Multiplexing, a technology that allows multiple data streams to be transmitted simultaneously over a single optical fiber.
DWDM uses multiple wavelengths of light to transmit data over a single fiber optic cable.
Each wavelength carries a separate data stream, allowing for high data capacity.
DWDM increases the capacity of optical networks by combining and transmitting multiple signals simultaneously.
It is commonly used in long-distance ...read more
Q338. Explain about Cieana..?
Cieana is a software-defined networking (SDN) solution that simplifies network management and automation.
Cieana allows for centralized control of network devices.
It enables dynamic network configuration and policy enforcement.
Cieana helps in optimizing network performance and security.
It supports integration with various network devices and protocols.
Example: Cieana can be used to automate network provisioning and ensure consistent network policies across an organization.
Q339. Explain L2vpn in detail
L2VPN stands for Layer 2 Virtual Private Network, which allows for the extension of a local area network (LAN) over a wide area network (WAN).
L2VPN operates at the data link layer (Layer 2) of the OSI model.
It enables the transparent transfer of Ethernet frames between sites.
L2VPN can be implemented using technologies such as Virtual Private LAN Service (VPLS) or Ethernet over MPLS (EoMPLS).
It provides secure and private communication between geographically dispersed sites.
L2...read more
Q340. Explain L3vpn working
L3VPN is a technology that allows multiple customers to use the same provider's network, while keeping their traffic separate.
L3VPN uses MPLS to create virtual private networks for different customers on a shared network infrastructure.
Each customer's traffic is kept separate using VPN routing and forwarding tables.
L3VPN provides secure and efficient communication between different sites of a customer's network.
It allows for flexible and scalable network configurations to mee...read more
Q341. nested if with loop vba
Nested if with loop in VBA
Nested if statements are used to check multiple conditions
Loops are used to repeat a set of instructions
Combining both can help in complex decision-making processes
Example: If a student's grade is above 90, check if they have completed all assignments using a loop
Q342. Wha about network
Networks are essential for communication between devices, allowing data to be shared and accessed.
Networks consist of interconnected devices such as computers, servers, routers, and switches.
Data is transmitted across networks using protocols like TCP/IP.
Network engineers design, implement, and maintain network infrastructures to ensure reliable communication.
Examples of network technologies include Ethernet, Wi-Fi, and VPNs.
Q343. What is dwdm otn
DWDM OTN stands for Dense Wavelength Division Multiplexing Optical Transport Network.
DWDM OTN is a technology that combines DWDM (Dense Wavelength Division Multiplexing) with OTN (Optical Transport Network) for high-capacity optical communication.
It allows multiple signals to be transmitted simultaneously over a single fiber optic cable by using different wavelengths of light.
DWDM OTN is commonly used in long-haul telecommunications networks to increase bandwidth and efficien...read more
Q344. softassert vs hardassert
SoftAssert allows test execution to continue after assertion failure, while HardAssert stops test execution.
SoftAssert is used when you want to continue executing the test even after an assertion failure.
HardAssert is used when you want to stop the test execution immediately after an assertion failure.
SoftAssert is commonly used in test automation frameworks like TestNG and JUnit.
HardAssert is commonly used in manual testing scenarios.
Q345. What is frequency
Frequency refers to the number of cycles of a wave that occur in a second.
Frequency is measured in Hertz (Hz).
It is used to describe the rate of oscillation of a wave.
In electrical engineering, frequency is used to describe the rate at which alternating current (AC) changes direction.
Examples of frequencies include radio waves, sound waves, and light waves.
Q346. Your Destination working
My destination is a remote island in the Pacific Ocean where I will be working on a conservation project.
Remote island in the Pacific Ocean
Working on a conservation project
Isolated from civilization
Opportunity to study unique wildlife
Q347. Infra working in Airtel
Working as an Infra technician in Airtel involves maintaining and troubleshooting network infrastructure for the telecommunications company.
Responsible for monitoring and maintaining network equipment
Troubleshooting network issues and resolving them in a timely manner
Collaborating with other teams to ensure smooth network operations
Implementing network upgrades and expansions
Documenting network configurations and changes
Q348. Ipms installation in Airtel
IPMS installation in Airtel involves setting up an Integrated Performance Management System for monitoring and managing network performance.
IPMS installation involves configuring the system to collect and analyze network performance data.
It includes setting up alerts and notifications for any performance issues detected.
Training the team on how to use the IPMS effectively is also part of the installation process.
Q349. Difference between joins
Joins are used to combine rows from two or more tables based on a related column between them.
Inner Join: Returns rows when there is a match in both tables.
Left Join: Returns all rows from the left table and the matched rows from the right table.
Right Join: Returns all rows from the right table and the matched rows from the left table.
Full Outer Join: Returns rows when there is a match in one of the tables.
Cross Join: Returns the Cartesian product of the two tables.
Q350. write sql query in pythons
Writing SQL queries in Python allows for seamless integration of data analysis and manipulation.
Use libraries like pandas or sqlalchemy to execute SQL queries in Python
Remember to establish a connection to the database before executing queries
Utilize Python's flexibility to manipulate and analyze data retrieved from SQL queries
Q351. Design a cache in Java
Design a cache in Java
Use a HashMap to store key-value pairs
Implement a mechanism to limit the size of the cache and remove least recently used items
Consider using a doubly linked list to keep track of the order of items in the cache
Q352. Complain Close at In SLA
Complain Close at In SLA
Ensure complaints are resolved within the agreed Service Level Agreement (SLA)
Track and monitor complaint resolution times to meet SLA deadlines
Communicate with customers to update them on the status of their complaints
Implement process improvements to reduce complaint resolution times
Train staff on efficient complaint handling techniques
Q353. Total work Nature of project
The total work nature of the project refers to the overall scope and type of tasks involved in the project.
Total work nature includes the extent of surveying and planning required for the project.
It also involves determining the resources, timeline, and budget for the project.
Examples of projects could range from land development projects to infrastructure projects like roads or bridges.
Q354. Fault repair on broadband
Fault repair on broadband involves troubleshooting and fixing issues with internet connectivity.
Identify the type of fault (hardware, software, connection)
Check cables and connections for any damage or loose connections
Restart the modem/router and devices to reset the connection
Contact the service provider for further assistance if needed
Q355. Android 14 changes?
Android 14 introduced new features like improved privacy controls, enhanced performance, and updated APIs.
Improved privacy controls with more granular app permissions
Enhanced performance optimizations for smoother user experience
Updated APIs for developers to utilize new functionalities
Introduction of new security features to protect user data
Q356. highest degree is
Master's degree in Education
Master's degree in Education
Completed graduate level coursework in education
Focused on advanced teaching methods and curriculum development
Q357. 5 qualities of cro
5 qualities of a good Store Manager
Strong leadership skills to effectively manage and motivate a team
Excellent communication skills to interact with customers, employees, and vendors
Organizational skills to ensure smooth operations and inventory management
Problem-solving abilities to address issues that arise in the store
Customer service orientation to prioritize customer satisfaction
Q358. design a get api .
Design a GET API to retrieve user information.
Define the endpoint for the API (e.g. /users/:id)
Include query parameters for filtering (e.g. /users?role=admin)
Return user data in JSON format
Handle errors gracefully (e.g. return 404 if user not found)
Q359. write a post APi
To create a post API for a backend system
Define the endpoint for the API (e.g. /posts)
Set up the HTTP method (e.g. POST)
Handle the request data and process it accordingly
Implement the necessary validation and error handling
Return a response with the appropriate status code and data
Q360. Field sales experience
Q361. Analysis of business
Analyzing the business performance and strategies
Evaluate financial statements for profitability and growth
Assess market trends and competition
Analyze customer feedback and satisfaction levels
Review operational efficiency and cost management
Identify areas for improvement and strategic opportunities
Q362. Test cases for login
Test cases for login functionality
Verify valid username and password combination successfully logs in
Verify error message is displayed for invalid username
Verify error message is displayed for invalid password
Verify user is redirected to forgot password page when forgot password link is clicked
Q363. Vision for broadband
To provide high-speed, reliable broadband services to connect individuals and businesses worldwide.
Expand network infrastructure to reach underserved areas
Offer competitive pricing to attract customers
Invest in cutting-edge technology for faster speeds
Provide exceptional customer service for satisfaction and retention
Q364. Make timer in react
Create a timer component in React for tracking time.
Use state to store the current time
Use setInterval to update the time every second
Display the time in a user-friendly format
Q365. Sell me this pen
This pen is not just a writing tool, but a stylish accessory that will make you stand out in any setting.
Highlight the sleek design and quality craftsmanship of the pen
Emphasize the smooth writing experience it provides
Mention how it is a practical and stylish gift for anyone
Q366. sales experience
I have 5 years of sales experience in the retail industry, consistently exceeding targets and building strong client relationships.
Exceeded sales targets by 20% for 3 consecutive years
Developed and implemented successful sales strategies
Built strong relationships with clients leading to repeat business
Trained new sales team members on effective selling techniques
Q367. write a code on BFS
Code for Breadth First Search algorithm
Use a queue to keep track of nodes to visit next
Visit each node's neighbors before moving to the next level
Mark visited nodes to avoid revisiting them
Q368. Installation of ont
ONT installation involves physical setup, configuration, and testing.
Ensure proper power supply and network connectivity for the ONT.
Mount the ONT on a wall or place it on a flat surface.
Connect the fiber optic cable to the ONT.
Configure the ONT settings based on the network requirements.
Test the ONT to ensure it is functioning correctly.
Q369. duplicate in a array
Find duplicates in an array of strings
Iterate through the array and store each element in a hash table
If an element is already in the hash table, it is a duplicate
Return the list of duplicates found
Q370. Explain Interfaces
Q371. Explain Channel
Q372. What is alter command
ALTER command is used to modify the structure of a database table.
ALTER command can be used to add, modify, or drop columns in a table.
It can also be used to rename a table or change its data type.
Example: ALTER TABLE table_name ADD column_name datatype;
Top HR Questions asked in Chandigarh University
Interview Process at Chandigarh University
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month