AVIZVA Senior Database Developer Interview Questions and Answers

Round duration - 50 minutes
Round difficulty - Medium

Round duration - 20 minutes
Round difficulty - Medium

Q1. 
Pair Sum Problem Statement
You are given an integer array 'ARR' of size 'N' and an integer 'S'. Your task is to find and return a list of all pairs of elements where each sum of a pair equals 'S'.
Note:
...read more
Ans. 
Given an array and a target sum, find pairs of elements that add up to the target sum.
• Iterate through the array and for each element, check if the complement (target sum - current element) exists in a hash set.

• If the complement exists, add the pair to the result list. Otherwise, add the current element to the hash set.

• Sort the pairs based on the first element and then the second element to meet the required output form
Answered by AI
Add your answer

Round duration - 20 minutes
Round difficulty - Easy

Round duration - 40 minutes
Round difficulty - Hard

Q1. Can you provide an example of how to use pointers in C/C++ and discuss different concepts related to them?
Ans. 
Pointers in C/C++ are variables that store memory addresses. They are used to manipulate memory directly and improve performance.
• Pointers are declared using an asterisk (*) before the variable name.

• Pointers can be used to dynamically allocate memory using functions like malloc() and free().

• Pointers can be used to pass variables by reference to functions.
Answered by AI
Add your answer

Q1. Based on Deep learning
Add your answer

Q1. Questions related to Speech to Text, Whisper AI, Transformers, Deep learning
Add your answer

Q1. Work culture fit and CEO round
Add your answer

Q1. Golang basics related questions
Add your answer
Q2. Concurrency related questions
Add your answer

Group discussion is very important thing.

Q1. HR round is very easy.
Add your answer
Q2. Just hard and smart work for.
Add your answer
Q3. What is requirement.
Ans. 
A requirement is a specific need or expectation that must be met in order to achieve a desired outcome.
• A requirement is a statement of what a product or service must do or how it must perform.

• Requirements can be functional (what the product must do) or non-functional (how well it must do it).

• Requirements should be clear, concise, and measurable.

• Examples of requirements include: the ability to save and retrieve data, a ...read more
Answered by AI
Add your answer
Q4. What is your strength.
Ans. 
My strength is problem-solving and analytical thinking.
• I have a strong ability to analyze complex problems and break them down into manageable components.

• I excel at finding innovative solutions and thinking outside the box.

• I am skilled in debugging and troubleshooting software issues.

• I have a solid understanding of algorithms and data structures.

• I am experienced in optimizing code for performance and efficiency.
Answered by AI
Add your answer
Q5. What is your weekness.
Ans. 
My weakness is that I tend to be too detail-oriented, which can sometimes slow down my progress.
• I have a tendency to get caught up in the small details and can spend too much time on them.

• I often find myself double-checking my work to ensure accuracy.

• I sometimes struggle with prioritizing tasks because I want to make sure everything is perfect.

• I am actively working on improving my time management skills to balance atte
Answered by AI
Add your answer

2 questions of DSA medium to hard