OSF Digital Senior QA Engineer -Software Testing Interview Questions and Answers

Q1. Write SQL query for getting the employee and manager name from the employee table
Ans. 
SQL query to retrieve employee and manager name from employee table
• Join employee table with itself using manager ID

• Select employee name and manager name from the joined table
Answered by AI
Add your answer
Q2. What are the different validations wpuld you do for a data migration project?
Ans. 
Validations for data migration project
• Verify data completeness and accuracy

• Check for data consistency and integrity

• Ensure data mapping and transformation is correct

• Validate data security and privacy

• Test data migration process end-to-end
Answered by AI
Add your answer

Q1. Testing concepts, workflow, decision making
Add your answer
Q2. Java Coding, SQL and debugging , automation testing, reporting
Add your answer

Q1. SQL query with join
Ans. 
SQL query with join
• Use JOIN keyword to combine rows from two or more tables based on a related column between them

• Specify the columns to select from each table in the SELECT statement

• Use ON keyword to specify the join condition
Answered by AI
Add your answer

Q1. SQL query with join
Ans. 
SQL query with join
• Use JOIN keyword to combine rows from two or more tables based on a related column between them

• Specify the columns to select from each table

• Use ON keyword to specify the join condition
Answered by AI
Add your answer

Q1. HR Round for Company review & offer
Add your answer

Jeneral knowledge questions

Q1. What is datatype
Ans. 
Datatype is a classification of data which tells the compiler or interpreter how the programmer intends to use the data.
• Datatypes specify the type of data that a variable can hold.

• Examples of datatypes include integers, floating-point numbers, characters, and strings.

• In programming languages like Java, C++, and Python, datatypes are used to define variables and functions.
Answered by AI
Add your answer
Q2. Date Types different types
Ans. 
Date types refer to different ways dates can be represented in software.
• Date

• Time

• DateTime

• Timestamp

• Interval
Answered by AI
Add your answer
Q3. Statement of DDL, DML, DQL.
Ans. 
DDL stands for Data Definition Language, DML stands for Data Manipulation Language, and DQL stands for Data Query Language.
• DDL is used to define the structure of database objects like tables, indexes, etc. Example: CREATE TABLE.

• DML is used to manipulate data in the database like inserting, updating, deleting records. Example: INSERT INTO.

• DQL is used to retrieve data from the database using queries. Example: SELECT * FR
Answered by AI
Add your answer

2 coding questions with 28 aptitude question in 1 hrs .

Q1. Data Structure,Java questions and basics of the sql
Add your answer

Coding Test consist of 3 coding question, 2 sql questions and 10 output question.

Q1. Project written on CV, Java questions, Scenario based question and 2 coding question 1. palindrome and string question.
Add your answer

Q1. Panel of 5 , with company CT0, Backend Manager, Android Team Manager and 2 more people. Java question based on String, Java, Scenario based question on testing like, coffee machine, lift, Water bottle, Pa...read more
Add your answer
Q2. Geeksforgeeks puzzle question 2, Aptitude question based on Probalility.
Add your answer

Q1. With HR and QA Team Manager
Add your answer
Q2. Aptitude and puzzle question. why you want to join company, what are your strengths and weakness, hobbies. Salary Discussion
Add your answer