Bhavna Corp. Senior QA Analyst Interview Questions and Answers

Q1. Basics of python, project related questions
Add your answer
Q2. Basic SQL, few simple problem solving questions
Add your answer

Q1. Interests, hobbies ,general HR questions
Add your answer
Q2. Expected hike, salary, work timings preferred
Add your answer

Q1. Interview based on your programming language , how good you know like java or python or scala
Add your answer
Q2. Big data & Data science interview question like working of spark , Hive optimization of queries , what is graphx
Add your answer
Q3. Explain your recent project in detail
Add your answer

Q1. More deep dive in your expertise technologies like Spark DAG working explain
Add your answer
Q2. How you do data validation in hive
Ans. 
Data validation in Hive involves using built-in functions and custom scripts to ensure data accuracy and consistency.
• Use built-in functions like IS NULL, IS NOT NULL, and COALESCE to check for missing or null values

• Use regular expressions and pattern matching to validate data formats

• Write custom scripts to perform more complex data validation tasks

• Perform data profiling to identify potential data quality issues

• Use data...read more
Answered by AI
Add your answer

Q1. Salary , why changing job etc..
Add your answer
Q2. Your complete background of career
Add your answer

Easy level questions on string, linked list and array

Q1. Difference between TCP and UDP
Ans. 
TCP is a connection-oriented protocol while UDP is connectionless.
• TCP provides reliable, ordered, and error-checked delivery of data while UDP does not guarantee any of these.

• TCP is slower but more reliable while UDP is faster but less reliable.

• TCP is used for applications that require high reliability and accuracy such as email, file transfer, and web browsing while UDP is used for applications that require speed and ...read more
Answered by AI
Add your answer
Q2. Nibble swap program in C
Ans. 
A nibble swap program in C
• Nibble swap means swapping the 4-bit halves of a byte

• Use bitwise operators to perform the swap

• Example: unsigned char x = 0xAB; x = ((x & 0x0F) << 4) | ((x & 0xF0) >> 4);
Answered by AI
Add your answer

Q1. Reverse Linked List in C
Ans. 
Reverse a linked list in C language.
• Create three pointers: current, previous, and next.

• Traverse the linked list and change the direction of the pointers.

• Return the new head of the reversed linked list.
Answered by AI
Add your answer
Q2. Write an API call in C
Ans. 
API call in C
• Include the necessary header files

• Create a URL string with the required parameters

• Use the curl library to make the API call

• Handle the response data appropriately
Answered by AI
Add your answer

Programming on basics of C

Programming on basics of C

Q1. Salary details and location preference
Add your answer

2 medium hard level questions. We just have to code and explain it. Platform doesn't have compilers.

Q1. Given an array Reverse array
Ans. 
Reverse array of strings
• Iterate through the array and swap elements from start to end

• Use two pointers, one at the beginning and one at the end, and swap elements until they meet
Answered by AI
Add your answer
Q2. Giaven a string Reverse string
Ans. 
Reverse a given string
• Use built-in functions like reverse() or loop through the string in reverse order

• Create a new string and append characters from the original string in reverse order

• Convert the string to an array of characters, reverse the array, and then join it back into a string
Answered by AI
Add your answer
Q3. Given array find sum of all elements
Ans. 
Calculate sum of all elements in a given array of strings
• Iterate through the array and convert each element to integer before adding to sum

• Handle edge cases like empty array or non-numeric elements

• Return the final sum after iterating through all elements
Answered by AI
Add your answer