Bharti Airtel Interview Questions, Process, and Tips for Experienced

Q1. Sql questions on fetching duplicate records and non duplicate records.
Add your answer
Q2. Get the 2nd highest salary employee details
Add your answer
Q3. Python: Write a code to get the duplicate letter in the string
Ans. 
Python code to find duplicate letters in a string
• Iterate through the string and keep track of the frequency of each letter using a dictionary

• Return the letters that have a frequency greater than 1 as duplicates
Answered by AI
Add your answer

Q1. Scenario based questions asked by manager mainly on campaigns run on ad servers Hand written answers
Add your answer

Sql test based on knowledge general and matha communication

Q1. About your self
Add your answer
Q2. Previous experience
Add your answer

Q1. Salary discussion
Add your answer
Q2. Privevious experience
Add your answer

Its was good and people are amazing here.

Q1. Code work n coding ,sql
Add your answer
Q2. Sql n technical questions
Add your answer

Leadership
Questions

Q1. Salary part discusdion
Add your answer
Q2. About myself n etc
Add your answer

Q1. Amazon: Add Cart feature - Write Selenium code
Ans. 
Use Selenium to automate adding items to cart on Amazon website.
• Locate the 'Add to Cart' button on the product page using Selenium's findElement method

• Click on the 'Add to Cart' button to add the item to the cart

• Verify that the item has been successfully added to the cart by checking the cart contents
Answered by AI
Add your answer
Q2. Test cases of Login API
Ans. 
Test cases for Login API
• Verify valid username and password login successfully

• Verify invalid username and password combination fails to login

• Verify login with empty username or password fails

• Verify login with special characters in username or password fails
Answered by AI
Add your answer
Q3. Write a program to count the character in a string
Ans. 
A program to count the characters in a string
• Iterate through each character in the string and increment the count for each character

• Use a hashmap to store the count of each character

• Handle edge cases like empty string or null input
Answered by AI
Add your answer
Q4. UI test cases of Upload document
Ans. 
UI test cases for uploading a document
• Verify that the 'Upload' button is functional

• Check if the correct file types are allowed for upload

• Ensure that the progress bar is displayed during upload

• Confirm that the document is successfully uploaded and visible on the UI
Answered by AI
Add your answer
Q5. UI test cases of a Form
Ans. 
UI test cases for a Form
• Verify all required fields are displayed

• Test validation messages for invalid inputs

• Check if form submission is successful

• Test the functionality of reset button
Answered by AI
Add your answer
Q6. How to achieve parallel execution of test cases in testNG?
Ans. 
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 paralle
Answered by AI
Add your answer
Q7. Write a program to reverse the words in a string I/P: My name is abc O/P: abc is name My
Ans. 
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
Answered by AI
Add your answer

Q1. Write a program to reverse the string. I/P: I LOVE JAVA O/P: A VAJE VOLI
Add your answer
Q2. Regression vs Sanity
Ans. 
Regression testing ensures existing functionality still works after changes, while sanity testing checks if new functionality works as expected.
• Regression testing is performed to make sure that new code changes do not adversely affect existing functionality.

• Sanity testing is a cursory testing to make sure that the new functionality is working as expected.

• Regression testing is usually automated and covers a wide range o...read more
Answered by AI
Add your answer
Q3. Explain automation framework
Ans. 
Automation framework is a set of guidelines, tools, and processes used to automate testing of software applications.
• Automation framework provides structure and guidelines for creating and executing automated tests.

• It helps in organizing test scripts, managing test data, and generating test reports.

• Examples of automation frameworks include Selenium, TestNG, and Cucumber.

• Frameworks can be data-driven, keyword-driven, or
Answered by AI
Add your answer
Q4. What are the reasons for 500 - Internal Server Error
Ans. 
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
Answered by AI
Add your answer
Q5. Submit button -> Click -> Blank page Identify the debug and find the root cause
Add your answer
Q6. Write test cases of an API that creates User's profile by accepting First name, Last name and mobile number
Ans. 
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 ...read more
Answered by AI
Add your answer

Q1. Knowledge about work ethics
Add your answer
Q2. How ro collaborate with multi tasking
Add your answer
Q3. Expected salary
Add your answer
Q4. Are you prepaired in flexible shifts 24*7 support
Add your answer
Q5. Comfortable in travelling & visit customers office
Add your answer

Q1. Skill based questions
Add your answer
Q2. Scenario based questions
Add your answer

Q1. Skill based questions
Add your answer
Q2. Scenario based questions
Add your answer