Bharti Airtel
300+ Shankaranarayana Constructions Interview Questions and Answers
Q1. Do you know abou Distributor ROI , If yes then pls explain how we calculate ROI with formula
ROI is a measure of profitability that evaluates the performance of an investment.
ROI is calculated by dividing the net profit by the cost of investment.
Net profit is the revenue generated minus the expenses incurred.
ROI can be expressed as a percentage or a ratio.
For example, if a distributor invests $10,000 and generates a net profit of $12,000, the ROI would be 20% ($2,000/$10,000).
Q2. N-th Fibonacci Number Problem Statement
Given an integer ‘N’, your task is to find and return the N’th Fibonacci number using matrix exponentiation.
Since the answer can be very large, return the answer modulo ...read more
Q3. If territory is totally collapsed , then what strategy you use to gane share of gross heads in that situation
In such a situation, I would focus on identifying potential customers and building relationships with them.
Conduct market research to identify potential customers
Develop a targeted marketing strategy to reach out to these potential customers
Build strong relationships with these customers through personalized communication and excellent customer service
Offer promotions or discounts to incentivize customers to switch to our product
Continuously monitor and adjust the strategy ba...read more
Q4. Study MPLS deeply: 1. What is MPLS ? 2. Purpose of MPLS ? 3. What is LDP and its working ? 4. CEF ? 5. MP-BGP 6. MPLS-VPN 7. VRF/RT/RD ? 8. Types and uses of labels ? 9. MPLS Traffic flow ? 10. MPLS header ? 11...
read moreMPLS is a protocol used to efficiently route network traffic by assigning labels to packets.
MPLS stands for Multiprotocol Label Switching
It is used to improve network performance and reduce congestion
LDP (Label Distribution Protocol) is used to distribute labels to network devices
CEF (Cisco Express Forwarding) is a fast switching technology used in MPLS networks
MP-BGP (Multiprotocol Border Gateway Protocol) is used to exchange routing information between different autonomous ...read more
Q5. Longest Common Prefix After Rotation
You are given two strings 'A' and 'B'. While string 'A' is constant, you may apply any number of left shift operations to string 'B'.
Explanation:
Your task is to calculate ...read more
Q6. Covid Vaccination Distribution Problem
As the Government ramps up vaccination drives to combat the second wave of Covid-19, you are tasked with helping plan an effective vaccination schedule. Your goal is to ma...read more
Q7. Longest Subarray with Zero Sum
Ninja enjoys working with numbers, and as a birthday challenge, his friend provides him with an array consisting of both positive and negative integers. Ninja is curious to identi...read more
Q8. What is your previous terratory size and how many distributors you handel
I managed a territory of 10 states with 15 distributors.
Managed a territory spanning 10 states
Handled a network of 15 distributors
Effectively coordinated sales activities across the territory
Developed strong relationships with distributors to drive sales growth
Q9. What do you know about Primary and secondary in general trade business
Primary and secondary are two levels of distribution channels in general trade business.
Primary distribution involves selling products directly to retailers or wholesalers.
Secondary distribution involves selling products to distributors who then sell to retailers or wholesalers.
Primary distribution is more profitable but requires more resources and effort.
Secondary distribution is less profitable but allows for wider reach and easier management.
Examples of primary and seconda...read more
Q10. Swap Kth Elements in an Array
Given an array ARR
of size N
, perform the operation to swap the Kth element from the beginning with the Kth element from the end of the array.
Example:
Input:
N = 5, K = 2
ARR = [1,...read more
Q11. How you appoint new distribution in rural area ?
To appoint new distribution in rural areas, I would follow a systematic approach involving market research, relationship building, and targeted outreach.
Conduct thorough market research to identify potential areas for expansion
Identify local influencers or community leaders who can help establish trust and credibility
Build relationships with key stakeholders such as retailers, wholesalers, and local authorities
Offer incentives or exclusive deals to attract distributors
Provide...read more
Q12. Character Frequency Problem Statement
You are given a string 'S' of length 'N'. Your task is to find the frequency of each character from 'a' to 'z' in the string.
Example:
Input:
S : abcdg
Output:
1 1 1 1 0 0 ...read more
Q13. In your team one member is doing good and one member is doing bad then what will you do
I will analyze the situation and take appropriate actions to improve the performance of the underperforming team member.
I will have a one-on-one meeting with the underperforming team member to understand the reasons behind their poor performance.
I will provide them with additional training and resources to help them improve their performance.
I will set clear goals and expectations for both team members and monitor their progress regularly.
I will recognize and reward the good ...read more
Q14. Tell me an analysis about how to factor customer or prospects for your product segment
To factor customers or prospects, analyze their needs, budget, decision-making process, and competition.
Identify the customer's pain points and how your product can solve them
Determine the customer's budget and if your product fits within it
Understand the customer's decision-making process and who the key decision-makers are
Analyze the competition and how your product compares
Consider the customer's industry and how your product can benefit them
Use data and analytics to track...read more
Q15. Stack using Two Queues Problem Statement
Develop a Stack Data Structure to store integer values using two Queues internally.
Your stack implementation should provide these public functions:
Explanation:
1. Cons...read more
Q16. Longest Consecutive Sequence Problem Statement
You are provided with an unsorted array/list ARR
of N
integers. Your task is to determine the length of the longest consecutive sequence present in the array.
Expl...read more
Q17. Trapping Rain Water Problem Statement
You are given a long type array/list ARR
of size N
, representing an elevation map. The value ARR[i]
denotes the elevation of the ith
bar. Your task is to determine the tota...read more
Q18. Left View of a Binary Tree
Given a binary tree, your task is to print the left view of the tree. The left view of a binary tree contains the nodes visible when the tree is viewed from the left side.
Input:
The ...read more
Q19. We have low infrastructure than compitition ,how could you manage the territory?
I would focus on building strong relationships with customers and providing exceptional service.
Identify the unique needs and pain points of customers and offer tailored solutions
Leverage technology and digital tools to maximize efficiency
Collaborate with other departments to optimize resources and support
Invest in training and development to enhance skills and knowledge
Differentiate from competition through superior customer service
Examples: Offering personalized product dem...read more
Q20. How can you turn around the difficult market? What will be your action plan?
To turn around a difficult market, I would focus on understanding the customers' needs and preferences, and then tailor my approach accordingly.
Conduct market research to identify customer needs and preferences
Develop a targeted marketing strategy based on research findings
Build strong relationships with key customers and stakeholders
Offer competitive pricing and promotions to attract new customers
Continuously monitor and adjust strategy based on market feedback
Q21. If you will go low potential area then what will you do for increasing sale
I will analyze the market and customer needs, create targeted marketing campaigns, and offer incentives to increase sales.
Conduct market research to understand customer needs and preferences
Create targeted marketing campaigns to reach potential customers
Offer incentives such as discounts or promotions to encourage sales
Build relationships with local businesses and community organizations to increase brand awareness
Provide excellent customer service to build loyalty and repeat...read more
Q22. Which features in LTE & VoLTE you have worked & what are values set for related parameters? Explain any 8 to 10 out of them.
I have worked on LTE & VoLTE features such as QoS, SRVCC, CSFB, TTI bundling, etc. and their related parameters.
QoS parameters such as ARP, QCI, GBR, MBR, etc.
SRVCC parameters such as HO margin, HO failure threshold, etc.
CSFB parameters such as timer values, RAT priority, etc.
TTI bundling parameters such as bundle size, bundle factor, etc.
VoLTE parameters such as AMR codec modes, RTP packetization, etc.
UE categories and their capabilities
eNodeB configuration parameters such a...read more
Q24. What do you understand by Growth?
Growth refers to the process of increasing in size, quantity, or value over time.
Growth can be measured in various ways such as revenue, market share, customer base, etc.
It is important for a company to have a growth strategy in place to achieve sustainable growth.
Growth can be achieved through various means such as expanding into new markets, introducing new products, improving customer experience, etc.
However, growth should not come at the cost of profitability or compromis...read more
Q25. What differentiates airtel from other telecom operators.
Airtel differentiates itself from other telecom operators through its extensive network coverage, innovative services, and customer-centric approach.
Extensive network coverage: Airtel has one of the largest network coverage in the country, ensuring reliable connectivity even in remote areas.
Innovative services: Airtel offers a wide range of innovative services such as Airtel Payments Bank, Airtel Thanks rewards program, and Airtel Xstream entertainment platform.
Customer-centr...read more
Q26. What do you know about the various products of Airtel? Describe about Cloud Services, MPLS, ILL, etc
Airtel offers various products including Cloud Services, MPLS, and ILL.
Airtel provides Cloud Services which allow businesses to store and access data remotely.
MPLS (Multiprotocol Label Switching) is a network protocol that ensures efficient data transfer between different locations.
ILL (Internet Leased Line) is a dedicated internet connection provided by Airtel for businesses.
Airtel also offers other products like broadband, mobile services, and digital TV.
Q27. What are HARQ & TTI Bundling? How these works & what is value set for HARQ in your network? and what are related parameters of TTI Bundling & their values?
HARQ & TTI Bundling are techniques used in wireless communication to improve data transmission efficiency.
HARQ stands for Hybrid Automatic Repeat Request and is used to improve the reliability of data transmission by retransmitting erroneous packets.
TTI Bundling stands for Transmission Time Interval Bundling and is used to reduce latency by transmitting multiple packets in a single transmission time interval.
The value set for HARQ in the network depends on the specific implem...read more
Q28. What is multiplexer and de multiplexer?
Multiplexer is a device that combines multiple signals into one signal. Demultiplexer is a device that separates one signal into multiple signals.
Multiplexer is also known as MUX.
It is used to increase the capacity of a communication channel.
Demultiplexer is also known as DEMUX.
It is used to route a single input signal to multiple output signals.
Multiplexer and demultiplexer are commonly used in digital communication systems.
Example: A 4:1 MUX can combine four input signals i...read more
Q29. How many digree angle cut fibre
The question is unclear and lacks context. Please provide more information.
What type of fibre is being referred to?
What is the purpose of the angle cut?
What equipment or tools are being used for the installation?
What is the specific job or project that requires this information?
Q30. What is difference between CFRA & CBRA? Can we fetch CFRA & CBRA success rate separately for RACH?
CFRA and CBRA are different algorithms used in RACH. Success rates can be fetched separately.
CFRA stands for Contention Free RACH Algorithm, while CBRA stands for Contention Based RACH Algorithm.
CFRA is used for devices with higher priority, while CBRA is used for devices with lower priority.
Success rates for CFRA and CBRA can be fetched separately by analyzing the RACH logs.
CFRA success rate is usually higher than CBRA success rate due to its priority usage.
Q31. What is maximum throughput we can achieve in LTE network with 20MHz TDD bandwidth?
The maximum throughput in LTE network with 20MHz TDD bandwidth depends on various factors.
Theoretical maximum throughput is 1.6 Gbps
Practical maximum throughput is around 1 Gbps
Actual throughput depends on factors like signal strength, interference, number of users, etc.
Carrier aggregation and MIMO can increase throughput
Real-world throughput can be measured using tools like speedtest.net
Q32. 1.What was internet? 2.how many years of experience? 3.what is that ASAP?
Internet is a global network of interconnected computers and servers that communicate with each other using standardized protocols.
Internet is a network of networks that allows communication and sharing of information across the globe.
It was developed in the late 1960s and early 1970s by the United States Department of Defense.
The World Wide Web, email, and instant messaging are some of the popular applications of the internet.
The internet has revolutionized the way we commun...read more
Q33. How many BTS you have and how you control??
I am not sure what you mean by BTS. Can you please clarify?
I am not familiar with the term BTS in this context. Can you please explain what you are referring to?
Without knowing what BTS stands for, I cannot answer this question.
I apologize, but I do not have the information you are asking for.
Q34. What you know about telecom industry?
Telecom industry refers to the companies that provide communication services through electronic means.
Telecom industry includes companies that provide services like voice calling, messaging, internet, and television.
Major players in the telecom industry include AT&T, Verizon, T-Mobile, and Sprint.
The industry has seen significant advancements in technology, such as the transition from 3G to 4G and now 5G networks.
Telecom industry is highly regulated by government agencies lik...read more
Q35. How would you upsell and cross sell a product
To upsell and cross sell a product, I would identify the customer's needs and offer complementary products or upgrades.
Listen to the customer's needs and preferences
Offer complementary products that enhance the original purchase
Suggest upgrades or premium versions of the product
Explain the benefits and value of the additional products
Provide personalized recommendations based on the customer's purchase history
Use persuasive language and highlight the advantages of the additio...read more
Q36. What you do for PS Drop improvement in LTE network?
I analyze network data to identify areas with high PS drops and work on optimizing those areas.
Analyze network data to identify areas with high PS drops
Optimize network parameters such as RSRP, RSRQ, SINR, etc.
Check for interference and adjust antenna tilt and azimuth
Ensure proper handover parameters are set
Perform drive tests to validate improvements
Collaborate with other teams such as RF and Core to resolve issues
Implement features such as Carrier Aggregation and MIMO to im...read more
Q37. How to handle Rural LRLU site
To handle Rural LRLU site, one needs to understand the local market, build relationships with key stakeholders, and provide tailored solutions.
Conduct market research to understand the local market and competition
Build relationships with key stakeholders such as local distributors, retailers, and community leaders
Provide tailored solutions that meet the unique needs of the rural market, such as smaller packaging sizes or lower prices
Offer training and support to ensure succes...read more
Q38. How many customer can be provided by OLT each port?
Q39. How will you convince a B2B customer to get our service considering the high competition in telecom field
I will highlight our unique value proposition, showcase our track record of success, offer competitive pricing, and provide excellent customer service.
Highlight our unique value proposition that sets us apart from competitors
Showcase our track record of success and customer satisfaction
Offer competitive pricing or special promotions to entice the customer
Provide excellent customer service and support to build trust and loyalty
Offer a free trial or demo to allow the customer t...read more
Q40. What is ILL, MPLS & P2P, COCP, PRI and should have field sales experience
ILL, MPLS & P2P, COCP, PRI are telecommunication terms. Field sales experience is preferred.
ILL stands for International Leased Line, a dedicated point-to-point circuit used for international data transmission.
MPLS & P2P are networking protocols used for data transfer between multiple locations.
COCP stands for Customer Owned Coincident Equipment, which refers to equipment owned by the customer and located on the service provider's premises.
PRI stands for Primary Rate Interfac...read more
Q41. What was your role in the project, specifically related to data transformation and dashboard creation?
I was responsible for data cleaning, transformation, and visualization to create interactive dashboards for stakeholders.
Performed data cleaning and transformation to ensure accuracy and consistency of data
Utilized tools like SQL, Python, and Tableau to manipulate and visualize data
Collaborated with stakeholders to understand their requirements and design interactive dashboards
Generated insights from data analysis to drive decision-making processes
Q42. How do you optimize and manage large datasets, and what data sources do you utilize to obtain this data?
I optimize and manage large datasets by using tools like SQL, Python, and Excel. I utilize various data sources such as databases, APIs, and web scraping.
Utilize SQL queries to efficiently extract and manipulate data from databases
Use Python for data cleaning, analysis, and visualization tasks
Leverage Excel for organizing and summarizing data in a user-friendly format
Obtain data from sources like internal databases, external APIs, and web scraping techniques
Q43. What you do for accessibility improvement in LTE network?
We ensure accessibility improvement in LTE network through various measures.
Conducting regular network audits to identify areas of improvement
Deploying small cells and repeaters to improve coverage in remote areas
Implementing carrier aggregation to increase network capacity
Providing network optimization services to improve network performance
Collaborating with device manufacturers to ensure compatibility with our network
Offering accessibility features on our devices such as t...read more
Q44. What you do for integrity (Throughput) improvement in LTE network?
I ensure proper parameter tuning, interference management, and capacity planning for LTE network throughput improvement.
Regularly monitor network KPIs to identify areas of improvement
Optimize network parameters such as handover parameters, antenna tilt, etc.
Implement interference management techniques such as interference coordination, power control, etc.
Perform capacity planning to ensure sufficient resources are available to handle traffic demand
Upgrade network hardware and...read more
Q45. What are the various cost items to be analysed in Telecom?
Various cost items in Telecom include network infrastructure, equipment, maintenance, marketing, and customer service.
Network infrastructure costs (e.g. towers, cables, routers)
Equipment costs (e.g. phones, modems, servers)
Maintenance costs (e.g. repairs, upgrades)
Marketing costs (e.g. advertising, promotions)
Customer service costs (e.g. call centers, support staff)
Q46. What are the details of your Key Performance Indicators (KPIs) and the achievements you have accomplished?
My KPIs include project completion rate, budget adherence, client satisfaction, and team performance.
Maintained a project completion rate of 95% by effectively managing timelines and resources
Achieved a budget adherence of 98% by closely monitoring expenses and making adjustments as needed
Received consistently high client satisfaction scores, with an average rating of 4.8 out of 5
Improved team performance by implementing regular feedback sessions and training programs
Q47. How to achieve parallel execution of test cases in testNG?
Parallel execution of test cases in TestNG can be achieved using TestNG's parallel attribute in the testng.xml file.
Set the 'parallel' attribute in the testng.xml file to 'methods', 'classes', or 'tests' to specify the level of parallelism.
Use the 'thread-count' attribute to specify the number of threads to be used for parallel execution.
Ensure that the test classes are thread-safe to avoid any conflicts during parallel execution.
Q48. comprehensive technique to judge the suitability of an individual and his appropriateness for admission, scholarship, job, etc. GD assesses the overall personality – thoughts,
A comprehensive technique to judge the suitability of an individual for admission, scholarship, job, etc.
Evaluate the candidate's qualifications, skills, and experience
Assess the candidate's communication and interpersonal skills
Analyze the candidate's problem-solving and critical thinking abilities
Consider the candidate's motivation, enthusiasm, and passion for the role
Evaluate the candidate's adaptability and ability to work in a team
Assess the candidate's leadership potent...read more
Q49. Write test cases of an API that creates User's profile by accepting First name, Last name and mobile number
Test cases for API creating User's profile with First name, Last name, and mobile number
Verify that a user profile is created successfully with valid First name, Last name, and mobile number
Test with invalid First name (empty, special characters, numbers)
Test with invalid Last name (empty, special characters, numbers)
Test with invalid mobile number (empty, alphabets, special characters, less than 10 digits)
Verify that duplicate profiles are not created for the same mobile num...read more
Q50. What is OFC?
OFC stands for Optical Fiber Cable, which is a type of cable made of glass or plastic fibers that transmit data using light.
OFC is used for high-speed data transmission over long distances.
It is commonly used in telecommunications, internet, and cable TV networks.
OFC is more reliable and has higher bandwidth than traditional copper cables.
Examples of OFC include single-mode fiber and multi-mode fiber.
OFC requires specialized equipment for installation and maintenance.
Q51. If you have to handle a territory, how will you keep up with the language as knowing the regional language can be highly effective in building long term relations
I will make an effort to learn the regional language through language courses, online resources, and practice with native speakers.
Take language courses to learn the basics of the regional language
Utilize online resources such as language learning apps and websites for further practice
Engage with native speakers to improve language skills and cultural understanding
Attend local events and immerse yourself in the language and culture of the territory
Regularly practice speaking ...read more
Q52. How to behave with customer ?
To behave with customers, one must be polite, attentive, empathetic, and proactive in addressing their needs and concerns.
Be polite and use courteous language.
Listen actively and attentively to the customer's concerns.
Show empathy and understanding towards their situation.
Be proactive in addressing their needs and resolving any issues.
Provide clear and concise information or instructions.
Maintain a positive and friendly attitude throughout the interaction.
Thank the customer f...read more
Q53. Which points should be remembered while doing plan?
Q54. Which entity has major involvement in SRVCC?
The mobile network operator has major involvement in SRVCC.
SRVCC stands for Single Radio Voice Call Continuity
It is a feature that allows a seamless handover of voice calls from LTE to 3G or 2G networks
The mobile network operator is responsible for implementing and supporting SRVCC
Q55. How many numbers done in a month,?
The number of sales done in a month varies based on the product, market demand, and sales strategy.
The number of sales done in a month depends on the product being sold.
Market demand plays a crucial role in determining the number of sales.
Sales strategy and execution can also impact the number of sales.
It is important to set realistic sales targets based on historical data and market trends.
Regular monitoring and analysis of sales data can help identify areas for improvement.
Q56. What are speech codecs being used in VoLTE?
VoLTE uses various speech codecs for efficient voice transmission.
AMR-WB (Adaptive Multi-Rate Wideband) codec is widely used in VoLTE.
Other codecs used include EVS (Enhanced Voice Services), Opus, and G.711.
The choice of codec depends on factors such as network capacity, device compatibility, and call quality requirements.
Q57. In which type support required for business growth
Business growth requires support in various areas such as marketing, sales, customer service, and product development.
Marketing support to increase brand awareness and attract new customers
Sales support to improve conversion rates and increase revenue
Customer service support to retain existing customers and improve satisfaction
Product development support to innovate and stay ahead of competitors
Financial support to invest in growth opportunities
Human resources support to hire...read more
Q58. What is the main thing matter in telecom.
Connectivity is the main thing that matters in telecom.
Reliable network coverage
Fast internet speeds
Affordable pricing
Innovative technology
Excellent customer service
Competitive pricing
Flexible plans
Ease of use
Security and privacy
Compatibility with devices
Integration with other services
Accessibility
Quality of voice and video calls
Q59. What are the reasons for 500 - Internal Server Error
500 Internal Server Error is a generic error message indicating a problem with the server.
Server misconfiguration
Server overload
Programming errors in server-side code
Database connection issues
Insufficient server resources
Q61. What I key difference in FDD & TDD network?
FDD and TDD are two different duplexing techniques used in wireless communication networks.
FDD stands for Frequency Division Duplexing while TDD stands for Time Division Duplexing.
In FDD, separate frequency bands are used for uplink and downlink communication while in TDD, the same frequency band is used for both uplink and downlink communication.
FDD is commonly used in 3G and 4G networks while TDD is commonly used in 5G networks.
FDD provides better voice quality and is more ...read more
Q62. What is ospf and OSI model
OSPF is a routing protocol used to exchange routing information within a single autonomous system. OSI model is a conceptual model used to describe network communication.
OSPF stands for Open Shortest Path First
It is a link-state routing protocol
OSPF uses Dijkstra's algorithm to calculate the shortest path
OSPF is used within a single autonomous system
OSI model has 7 layers: Physical, Data Link, Network, Transport, Session, Presentation, and Application
It is a conceptual model ...read more
Q63. What is a OSPF and explain stages
OSPF is a routing protocol used in computer networks to determine the best path for data to travel.
OSPF stands for Open Shortest Path First
It is a link-state routing protocol
OSPF routers exchange information about the network topology to determine the best path for data to travel
There are several stages in OSPF: neighbor discovery, database synchronization, and route calculation
OSPF uses a hierarchical structure with areas to reduce the amount of routing information that need...read more
Q64. How going on distribution not react your said things
I'm sorry, but the question is not clear and seems to be incomplete.
Please provide more context or rephrase the question.
It is difficult to understand what is being asked.
Without further information, I cannot provide a relevant answer.
Q65. How to install https server and integrated with weblogic server.
To install https server and integrate with weblogic server, follow these steps:
Generate a SSL certificate for the https server
Configure the https server to use the SSL certificate
Configure the weblogic server to use the https protocol
Update the weblogic server's configuration to use the SSL certificate
Restart both servers to apply the changes
Q66. What are the parameters used for Key Performance Indicators (KPI) and scorecards?
Parameters for KPI and scorecards include relevance, measurability, achievability, time-bound, and alignment with organizational goals.
Relevance: KPIs should directly align with the objectives of the project or organization.
Measurability: KPIs should be quantifiable and measurable to track progress.
Achievability: KPIs should be realistic and achievable within the given resources.
Time-bound: KPIs should have a specific timeframe for achievement.
Alignment with organizational go...read more
Q67. How to manage store n properly maintained store inventory..
To manage store inventory properly, implement effective inventory management systems, conduct regular audits, optimize stock levels, and train staff on inventory management.
Implement inventory management systems to track stock levels, sales, and replenishment needs.
Conduct regular inventory audits to identify discrepancies and ensure accuracy.
Optimize stock levels by analyzing sales data, forecasting demand, and adjusting reorder points.
Train store staff on proper inventory m...read more
Q68. What is ROI?
ROI stands for Return on Investment.
ROI is a financial metric used to measure the profitability of an investment.
It is calculated by dividing the net profit by the cost of the investment.
ROI can be expressed as a percentage or a ratio.
For example, if you invest $100 and make a profit of $20, your ROI would be 20%.
ROI is an important factor in decision-making for businesses and investors.
Q69. Which fiber grade were we using in RJIL?
Q70. What is the Fiber link budget for FTTX?
Q71. What was target for the current month
The target for the current month was to achieve a sales revenue of $500,000.
The target was set at the beginning of the month by the sales team.
It was based on the previous month's sales performance and market trends.
The target was communicated to all the sales representatives and managers.
Regular progress updates were shared to ensure the target was on track.
The target was achieved by the end of the month through effective sales strategies and customer engagement.
The target f...read more
Q72. Write a program to reverse the words in a string I/P: My name is abc O/P: abc is name My
Program to reverse words in a string
Split the input string into an array of words
Reverse the array of words
Join the reversed array back into a string
Q73. do have experience of working on no code -low code platform?
Yes, I have experience working on no code-low code platforms.
I have worked on platforms like OutSystems and Mendix which are considered no code-low code platforms.
I have developed applications using visual drag-and-drop interfaces and pre-built components.
These platforms allow for rapid application development without the need for traditional coding.
I have experience in creating workflows, data models, and user interfaces using these platforms.
I have also integrated external ...read more
Q74. Guesstimate : Daily revenue of Domino's pizza in gurgaon.
Guesstimate the daily revenue of Domino's pizza in Gurgaon.
Consider the number of outlets in Gurgaon
Estimate the average number of pizzas sold per outlet per day
Multiply the number of pizzas by the average price of a pizza
Factor in any promotions or discounts that may affect revenue
Consider the day of the week and time of day as they may affect sales
Q75. Why a customer buy anything from you like a pen figure out the points
Customers buy from us because we offer quality products and excellent customer service.
We offer a wide range of high-quality products to choose from.
Our prices are competitive and affordable.
We provide excellent customer service and support.
We offer fast and reliable shipping and delivery options.
We have a hassle-free return and exchange policy.
We offer special promotions and discounts to our loyal customers.
Q76. How to manage distributer and retailer
To manage distributors and retailers effectively, communication, relationship-building, and strategic planning are key.
Establish clear communication channels with distributors and retailers to ensure smooth operations
Build strong relationships based on trust and mutual benefit
Provide training and support to help distributors and retailers succeed
Develop strategic plans to optimize distribution and retail channels
Regularly review performance metrics and adjust strategies as ne...read more
SQL query to find the second highest salary
Use the ORDER BY clause to sort the salaries in descending order
Use the LIMIT clause to limit the result to the second row
Use a subquery to exclude the highest salary from the result
Q78. What is 3 success Key?
The 3 success keys are hard work, persistence, and adaptability.
Hard work is essential to achieving goals and overcoming obstacles.
Persistence is necessary to keep going even when faced with challenges or setbacks.
Adaptability is important to be able to adjust to changing circumstances and stay relevant.
For example, a successful salesperson may work long hours, follow up consistently with leads, and be willing to try new approaches to close deals.
Another example is a successf...read more
Q79. What is your proficiency with Excel, PowerPoint and PowerBI?
Proficient in Excel, PowerPoint, and PowerBI for financial analysis and reporting.
Advanced Excel skills including VLOOKUP, pivot tables, and macros
Experience creating professional presentations in PowerPoint
Knowledge of data visualization and analysis in PowerBI
Used Excel for financial modeling, forecasting, and budgeting
Created interactive dashboards in PowerBI for real-time data analysis
Q80. Enough stock already billed to Partner but yet need to bill huge Primary. What will be action plan?
Analyze the stock and prioritize the billing process based on urgency.
Check the inventory levels of both Partner and Primary.
Analyze the demand and urgency of the Primary order.
Prioritize the billing process based on urgency.
Communicate with the Partner to ensure timely delivery of the billed stock.
Replenish the stock levels to avoid future delays.
Q81. What is the colour code of 24 core fiber
The color code of a 24 core fiber varies depending on the specific standard being followed.
The most commonly used color code for a 24 core fiber is based on the TIA/EIA-598 standard.
In this standard, the fibers are color-coded using a combination of colors and stripes.
The first 12 fibers are typically solid colors, while the remaining 12 fibers have a colored stripe on a white background.
The specific color sequence may vary depending on the manufacturer or installation requir...read more
Q82. Tell me about sales?
Sales is the process of persuading and convincing potential customers to purchase a product or service.
Sales involves building relationships with customers and understanding their needs.
It requires effective communication and negotiation skills.
Salespeople use various techniques such as cold calling, presentations, and demonstrations.
Meeting sales targets and generating revenue are key objectives in sales.
Sales can involve both B2B (business-to-business) and B2C (business-to-...read more
Q83. What will you do I customers start cancelling the order on the Urban company?
I will analyze the reasons for cancellations, address any issues, improve customer experience, and implement strategies to retain customers.
Analyze the reasons for cancellations to identify any common issues or trends
Address any issues that are leading to cancellations, such as poor service quality or pricing concerns
Improve customer experience by enhancing service offerings, providing better communication, or offering discounts or promotions
Implement strategies to retain cus...read more
Q84. What is fiber optic & FTTH known
Fiber optic is a technology that uses thin glass or plastic fibers to transmit data over long distances. FTTH stands for Fiber to the Home, which is a type of broadband internet service that uses fiber optic cables to deliver high-speed internet directly to homes.
Fiber optic technology uses light to transmit data instead of electrical signals
Fiber optic cables are made up of thin glass or plastic fibers that are bundled together
FTTH is a type of broadband internet service tha...read more
Q85. How good you are with Data to take make decisions, explain with example
I am proficient in data analysis and use it to make informed decisions.
I have experience in using various data analysis tools such as Excel, SQL, and Tableau.
I always ensure that the data I use is accurate and reliable.
I use data to identify trends and patterns, and make decisions based on those insights.
For example, in my previous role, I analyzed customer data to identify areas where we could improve our product offerings and increase sales.
I also use data to track the succ...read more
Q86. What are the details of the telecommunication products?
Telecommunication products include devices and services used for communication over long distances.
Telecommunication products can include smartphones, landline phones, routers, modems, and satellite phones.
Services such as internet, phone, and cable TV are also considered telecommunication products.
Examples of telecommunication companies include AT&T, Verizon, and T-Mobile.
Q87. What are the detailed concepts and principles of topology?
Topology is a branch of mathematics that deals with the properties of space that are preserved under continuous deformations.
Topology studies the properties of space that are preserved under continuous deformations.
It focuses on concepts like continuity, compactness, connectedness, and convergence.
Examples include the study of shapes like spheres, tori, and Möbius strips.
Topology is used in various fields such as physics, computer science, and biology.
Q88. Three protocols are essential for Networking domain. OSPF,ISIS,BGP
OSPF, ISIS, and BGP are three essential protocols in the Networking domain.
OSPF (Open Shortest Path First) is a link-state routing protocol used for interior routing within a single autonomous system.
ISIS (Intermediate System to Intermediate System) is a link-state routing protocol used for interior routing within a single autonomous system.
BGP (Border Gateway Protocol) is a path-vector routing protocol used for routing between autonomous systems.
OSPF and ISIS are used for in...read more
Q89. How to Handle Large Account??
Handling large accounts requires strategic planning and effective communication.
Develop a strong relationship with the client
Assign a dedicated account manager
Create a customized plan for the client's needs
Regularly communicate with the client to ensure satisfaction
Anticipate and address any potential issues
Provide exceptional customer service
Use data analysis to identify opportunities for growth
Collaborate with other departments to provide comprehensive solutions
Q90. What's your plan to increase sales in B2B environment?
My plan to increase sales in a B2B environment involves building strong relationships with key accounts, identifying their needs, offering tailored solutions, and providing excellent customer service.
Develop a deep understanding of the key accounts' business goals and challenges
Offer personalized solutions that address the specific needs of each key account
Provide exceptional customer service to build trust and loyalty
Regularly communicate with key accounts to ensure their sa...read more
Q91. What are reflector,arms,foot mount, connector and wire?
Reflector, arms, foot mount, connector, and wire are components used in satellite dish installation.
Reflector: The dish-shaped component that reflects and focuses satellite signals.
Arms: Metal supports that hold the reflector in place.
Foot mount: The base or stand on which the satellite dish is mounted.
Connector: A device used to join or connect cables.
Wire: Conductive material used to transmit electrical signals.
Q92. Describe about S1, S2 splitter and How you can calculate power loss ?
Q93. How would you handle the customer?
I would handle the customer by actively listening to their concerns, empathizing with their situation, and providing a prompt and satisfactory resolution.
Listen attentively to the customer's issue
Show empathy and understanding towards their situation
Ask clarifying questions to gather more information
Offer a solution or alternative options
Ensure the customer is satisfied with the resolution
Follow up to ensure the issue is fully resolved
Q94. What is communication ? Define TP IP protocol?
Communication is the exchange of information between two or more parties.
Communication involves a sender, a message, a channel, a receiver, and feedback.
It can be verbal or nonverbal, written or spoken, and can occur through various mediums such as email, phone, or face-to-face.
Effective communication is essential for successful relationships, both personal and professional.
TCP/IP is a protocol used for communication between devices on a network.
TCP (Transmission Control Prot...read more
Q95. what is ADB? its basic commands?
ADB stands for Android Debug Bridge. It is a command-line tool that allows communication between a computer and an Android device.
ADB can be used to install and debug apps on Android devices.
Some basic ADB commands include 'adb devices' to list connected devices, 'adb install' to install an app, and 'adb logcat' to view device logs.
ADB can also be used to push and pull files between a computer and an Android device.
Q96. What is vrrp and harp and how it functions?
VRRP (Virtual Router Redundancy Protocol) and HARP (High Availability Redundancy Protocol) are protocols used for providing redundancy in network routing.
VRRP is used to provide a virtual IP address that multiple routers can share, ensuring high availability in case of router failure.
HARP is a proprietary protocol developed by Cisco that also provides redundancy by allowing multiple routers to share a virtual IP address.
Both VRRP and HARP function by electing a master router ...read more
Q97. What is router and firewall and state difference?
A router is a networking device that forwards data packets between computer networks, while a firewall is a security system that monitors and controls incoming and outgoing network traffic.
Router directs traffic between different networks based on IP addresses.
Firewall filters network traffic based on predetermined security rules.
Routers operate at layer 3 (network layer) of the OSI model, while firewalls operate at layer 4 (transport layer) or higher.
Example: Cisco routers a...read more
Q98. Guesstimates like how many traffic signals are there in Noida.
There are approximately 500-600 traffic signals in Noida.
Estimate based on the size and population of Noida
Consider the number of major intersections and roads in the city
Take into account the traffic density and need for traffic management
Consult local traffic authorities for more accurate data
Q99. How to ensure pull-based learning instead of push-based learning?
To ensure pull-based learning, provide learners with resources and opportunities to seek out information and apply it in real-world scenarios.
Encourage self-directed learning through access to online resources and mentorship programs
Provide opportunities for hands-on learning and real-world application of knowledge
Create a culture of continuous learning and growth within the organization
Offer incentives for employees who take initiative in their own learning and development
Us...read more
Q100. Describe in detail all the header fields of the MPLS.
MPLS header fields and their functions
Label: identifies the forwarding equivalence class (FEC)
Exp: experimental use, can be used for QoS
S: bottom of stack bit, indicates if this is the last label in the stack
TTL: time to live, decremented at each hop
Optional fields: used for VPNs, traffic engineering, etc.
Top HR Questions asked in Shankaranarayana Constructions
Interview Process at Shankaranarayana Constructions
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month