SQL Questions
1. Difference between WHERE and HAVING clauses.
2. When to use ROW_NUMBER(), RANK(), and DENSE_RANK().
3. Explain window functions with examples.
4. Write a query to find the second-highest salary from an employee table.
5. How do you optimize an SQL query?

Learn SQL Basics for Data Science

Deloitte Senior Test Automation Engineer Interview Questions

𝐑𝐨𝐮𝐧𝐝 1: (𝐓𝐞𝐜𝐡𝐧𝐢𝐜𝐚𝐥)

1. Explain about yourself and your roles and responsibilities.
2. Write Java code to reverse a string while preserving the whitespace.
3. Given an SQL table, find the second-largest salary of an employee.
4. Explain the concept of joins and list the different types of joins available.
5. What is LinkedHashMap? Explain its use.
6. Explain black-box testing and white-box testing.
7. What is the difference between an exception and an error?
8. Difference between findElement and findElements.
9. What is the difference between implicit wait and explicit wait?
10. Write Selenium code to automate a calendar WebElement.
11. How would you fetch the text from a text box in Selenium?
12. How do you enter text in an alert using Selenium?
13. What is the difference between checked and unchecked exceptions?
14. If an XPath selects two elements on a webpage, does findElement throw an exception?
15. Explain smoke testing and sanity testing.
16. What are relative locators in Selenium?
17. Explain the challenges you faced in your project.
18. How would you pick test cases for regression testing?

𝐑𝐨𝐮𝐧𝐝 2: (𝐓𝐞𝐜𝐡𝐧𝐨-𝐌𝐚𝐧𝐚𝐠𝐞𝐫𝐢𝐚𝐥)
1. Explain your framework in detail.
2. In your framework, if you have 100 pages, do you create 100 Page Objects?
3. What is an “Element click intercepted” exception, and how do you fix it?
4. How do you take screenshots for failed test cases only in TestNG?
5. Explain how to connect your test cases with Azure.
6. What is the get fetch command?
7. In Postman, how do you delete a variable after test execution is finished?
8. Why do you prefer using Cucumber BDD in your project?
9. Explain dynamic binding and static binding.
10. What is method overloading, and what is method overriding?
11. What is the difference between Comparable and Comparator?
12. How would you conclude that a login page is user-friendly?
13. What are 5 points you consider when writing a good test case?
14. Suppose a developer is not fixing a bug; how would you approach the situation?
15. What are the threads in JMeter?
16. Can you automate captchas?
17. In what cases would you require fluent waits?
18. In Selenium, how would you open a new tab?
19. In Jenkins, what is the purpose of a CRON expression?

𝐑𝐨𝐮𝐧𝐝 3 ( 𝐇𝐫 𝐃𝐢𝐬𝐜𝐮𝐬𝐬𝐢𝐨𝐧 )

Grab your 𝐔𝐥𝐭𝐢𝐦𝐚𝐭𝐞 𝐐𝐀/𝐒𝐃𝐄𝐓 𝐊𝐢𝐭 Now!

🚀 New Video Alert! 🚀

Hey everyone! I just uploaded a brand new tutorial on YouTube to help you get started with Selenium Automation! 🧑‍💻💻

In this video, I’ll show you how to easily install and set up everything you need for Selenium, including:

Java ☕️
Eclipse IDE 💻
WebDriver 🧑‍💻
Whether you're a beginner or looking to refresh your knowledge, this step-by-step guide will have you automating tests in no time! 🔧✨

👉 Check out the video now:
https://youtu.be/6Tzmy8uxQAM

Don't forget to like, subscribe, and hit the bell icon to stay updated with more tutorials from CoderBaba! 👍🔔

#SeleniumSetup #AutomationTesting #CoderBaba #JavaForSelenium #EclipseIDE #WebDriver #TestAutomation #LearnWithCoderBaba #SeleniumTutorial #Automation #TechTutorials #BeginnersGuide

Let’s get automating! 🚀

Java Programming PDF Book