Bharti Airtel Interview Questions, Process, and Tips

Q1. How to handle current issue in weblogic server.
Ans. 
To handle current issue in weblogic server, identify the root cause and apply appropriate solution.
• Identify the root cause of the issue

• Check server logs for errors and exceptions

• Apply appropriate solution based on the issue

• Restart the server if necessary

• Monitor the server for any further issues
Answered by AI
Add your answer
Q2. How to apply patches in weblogic server.
Ans. 
Patches in WebLogic server can be applied using Smart Update utility or through command line using OPatch.
• Download the patch from Oracle support website

• Stop all the servers and take a backup of the domain

• Apply the patch using Smart Update utility or OPatch command line tool

• Restart the servers and verify the patch installation
Answered by AI
Add your answer
Q3. How to install weblogic server and configure.
Ans. 
To install WebLogic server, download the installer, set up the environment, and run the installer. Configure by creating domains and deploying applications.
• Download the WebLogic server installer from Oracle's website

• Set up the environment variables for Java and WebLogic

• Run the installer and follow the prompts

• Create domains to manage server instances and deploy applications

• Configure server settings such as security and
Answered by AI
Add your answer
Q4. How to install https server and integrated with weblogic server.
Ans. 
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
Answered by AI
Add your answer

Q1. Mere pahle experience ke bare mein
Ans. 
1 years sbi bank me and 3 year kotak Mahindra Bank limited me
Answered Anonymously
Add your answer
Q2. Aur mere bare mein mere karya karne ki kshamta ke bad
Ans. 
Mera Naam Ho Raha hai main UP Jaunpur jile se hun aur mere family mein meri mummy papa Bhai bahan hai aur main graduation BSc final kiya hun 2018 mein Kanpur University se.
Answered Anonymously
Add your answer

Meri salary aur meri expectation ke bare mein

Q1. Ham kis tarah se Kam karenge vah sab detail mein
Add your answer
Q2. Aur company ke bare mein kuchh detail mein bataenge kaise aur kam karte hain call kar sakte hain
Ans. 
Hamar jo total work tha abhi tak ka banking work tha customer ke sath relation maintain karna hota tha aur customer se le Lena hota tha banking ke account se bank account current account
Answered Anonymously
Add your answer

Kuchh bhi kahe samasya aati hai karya karne mein ham kaise theek karenge yah sab ke bare mein

Ham kya accepted test

Q1. Technical kya problem a raha hai vah sab solve karne ke bad
Add your answer
Q2. Aur ham log solve karke dekh ke upar se service denge
Add your answer

Q1. Kuchh bhi problem aata hai uska round pura ham follow Karen solve karenge 100%
Add your answer
Q2. Customer ko udaas nahin jaane denge ham usse kuchh Na kuchh karenge
Add your answer

Q1. Could you elaborate on your roles and responsibilities in your previous employment?
Ans. 
In my previous role, I was responsible for analyzing data, creating reports, and providing insights to support decision-making.
• Performed data cleaning, transformation, and analysis using tools like Excel, SQL, and Python.

• Generated reports and dashboards to visualize data trends and patterns.

• Collaborated with cross-functional teams to identify key metrics and KPIs for business performance.

• Presented findings and recommen...read more
Answered by AI
Add your answer
Q2. What was your role in the project, specifically related to data transformation and dashboard creation?
Ans. 
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 d
Answered by AI
Add your answer
Q3. How do you optimize and manage large datasets, and what data sources do you utilize to obtain this data?
Ans. 
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, ex
Answered by AI
Add your answer
Q4. Guesstimates like how many traffic signals are there in Noida.
Ans. 
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
Answered by AI
Add your answer
Q5. The interviewer asked SQL questions related to window functions, joins, and advanced aggregations, such as running sum and rolling sum.
Add your answer

Q1. Second round is also a technical round and similar to first round . Medium to high level sql questions and questions related to the project you're working on and Guesstimates will be asked by the interview...read more
Add your answer

Q1. Project manager will take the third round interview and inquire about your knowledge of the company, and some technical and scenario-based questions related to decision-making and problem-solving approach.
Add your answer

Q1. Final round will be an HR round.
Add your answer

Q1. Zambia, Tanzania, Nigeria,chad.congo.b
Add your answer
Q2. Vode dump Zambia
Ans. 
Vode dump copy then Extract again merge then ..
Answered by FIDAUL HAOUE
Add your answer
Q3. What is alter command
Ans. 
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;
Answered by AI
View 1 more answer
Q4. What is join ,Equi join,inner join,Left outer join full outer join
Add your answer
Q5. Type of constraints Primary key,not null,check, unique, default, foreign key
Add your answer