1.) Tell Me about Yourself
2.) Tell me about your last project with technical details
3.) What is SDLC Model?
4.) What is STLC Model?
5.) BUG LIFE CYCLE
6.) Severity and Priority
7.) Regression Testing
8.) Smoke and Sanity
9.) Retesting
10.) API Testing (GET, PUT, POST, DELETE and status codes) same question for API Automation Testing.
In API Automation track particular data from response
Ans -> String str=object.path(“data.email_id”);
11.) Agile Methodology
12.) JIRA
13.) Database Query Questions
1.) Write a query to find the highest salary in the employee table.
Answer:
SELECT MAX(salary) AS highest_salary
FROM employee;
2.) Write a query to list the number of employees in each department.
Answer:
SELECT department_id, COUNT(*) AS employee_count
FROM employee
GROUP BY department_id;
3.) Write a query to fetch all employees who joined in the year 2023.
Answer:
SELECT *
FROM employee
WHERE YEAR(join_date) = 2023;
4.) Write a query to calculate the average salary of employees in each department.
Answer:
SELECT department_id, AVG(salary) AS average_salary
FROM employee
GROUP BY department_id;
5.) Write a query to fetch the details of employees whose last name starts with 'A'.
Answer:
SELECT *
FROM employee
WHERE last_name LIKE 'A%';
14.) POM.xml file
15.) Maven
16.) Java Automation Questions
1 -> Prime Number Program in Java
2 -> How to Reverse a Number in Java
3 -> Palindrome Program in Java
4 -> Java Program to find the frequency of each element in the array
5 -> Java Program to print the duplicate elements of an array String
6 -> Java Program to Remove Duplicate Element in an array
7 -> Java Program to determine whether a given string is palindrome
8 -> Java Program to find maximum and minimum occurring character in a string
9 -> Java Program to find Reverse of the string
10 -> Sorting & Searching
11 -> Java Program to find the frequency of each element in the String ex - "abcABC123!#@gmail.com"
Output is a=3, b=3, c=3, g=1, m=1, i=1, l=1, o=1, m=1
(Use Refexing in this & HashMap Concept)
12 -> Input -> abcdd output -> abcd
(Use HashSet in this)
13 -> 11 & 12 same question also for String
17.) Please automate this website https://demoqa.com/forms
18.) Write test cases for this https://www.saucedemo.com
19 -> Locators & write xpath for particular thing(Dynamic or relative)
20 -> Waiting System
21 -> Exception Handing (some exception example)