Edvoy Data Engineer Interview Questions and Answers

Q1. What data structure is used to implement a priority queue?
Ans. 
Binary heap is used to implement a priority queue.
• Binary heap is a complete binary tree where each node has a value greater than or equal to its children.

• It can be implemented using arrays, where the parent of node at index i is at index (i-1)/2.

• Insertion and deletion operations have time complexity of O(log n) in a binary heap.
Answered by AI
Add your answer
Q2. How many trees will a binary tree have?
Ans. 
A binary tree can have any number of nodes, but the maximum number of trees with n nodes is 2^n.
• A binary tree can have 0 nodes, 1 node, 2 nodes, or any number of nodes.

• The maximum number of binary trees with n nodes is 2^n.

• For example, a binary tree with 3 nodes can have up to 8 different structures.
Answered by AI
Add your answer

Q1. SQL Query to return the second highest marks in a student database
Ans. 
Use a SQL query to find the second highest marks in a student database.
• Use the ORDER BY clause to sort the marks in descending order

• Use the LIMIT clause to limit the result to the second row
Answered by AI
Add your answer
Q2. Program to check if two strings are anagrams
Ans. 
Program to check if two strings are anagrams
• Create a function that takes in two strings as input

• Remove any spaces and convert both strings to lowercase for consistency

• Sort the characters in both strings and compare if they are equal to determine if they are anagrams

• Example: 'listen' and 'silent' are anagrams
Answered by AI
Add your answer

Sql, numpy, pandas, dictionary, pandas group by, merging

Q1. Normal questions
Add your answer

Q1. Tell us about yourself
Ans. 
I am a software engineer with 5 years of experience in developing web applications using Java, Spring, and Angular.
• 5 years of experience in software development

• Proficient in Java, Spring, and Angular

• Strong problem-solving skills

• Experience working in Agile environments

• Passionate about learning new technologies
Answered by AI
Add your answer
Q2. What are salary expectations
Ans. 
Salary expectations should be based on industry standards, experience, and location.
• Research industry standards for the specific role and location

• Consider your level of experience and skills

• Factor in cost of living in the area where the job is located

• Be prepared to negotiate based on the job responsibilities and benefits package
Answered by AI
Add your answer
Q3. Resume background screening
Add your answer
Q4. Commuting distance
Add your answer
Q5. Why you want to work?
Ans. 
I am passionate about solving complex problems and creating innovative solutions through software engineering.
• Passion for problem-solving

• Interest in creating innovative solutions

• Excitement for software engineering challenges
Answered by AI
Add your answer

Q1. What is key features python programming
Ans. 
Key features of Python programming include simplicity, readability, versatility, and extensive libraries.
• Python is known for its simple and readable syntax, making it easy to learn and understand.

• It is a versatile language that can be used for various purposes such as web development, data analysis, and artificial intelligence.

• Python has a vast collection of libraries and frameworks that provide ready-to-use tools for ...read more
Answered by AI
Add your answer
Q2. What is pandas word?
Ans. 
Pandas is a powerful data manipulation library in Python, used for data analysis and data wrangling tasks.
• Pandas is a Python library that provides data structures and functions for efficient data manipulation.

• It is widely used for tasks like data cleaning, transformation, and analysis.

• Pandas offers powerful tools for handling structured data, such as CSV or Excel files.

• It provides functionalities like filtering, sortin...read more
Answered by AI
Add your answer
Q3. Different between seaborn and matplotlib
Ans. 
Seaborn is a high-level interface for statistical data visualization, while Matplotlib is a low-level library for creating basic plots.
• Seaborn provides a more aesthetically pleasing and informative visual representation of data compared to Matplotlib.

• Seaborn has built-in themes and color palettes that make it easier to create visually appealing plots.

• Matplotlib offers more flexibility and control over plot customizatio...read more
Answered by AI
Add your answer

You can take my test to check my IQ level and problem solving as in aptitude keep mathmatics problems.

In c,c++ and Java questions and you ask me question from data base query like SQL query.

Q1. 1.In HR round you can check out my all other things carrer related, job perspective also. 2.if they want to check my apptitute ,job related questions in any way so they ask me.
Add your answer
Q2. For job related questions .
Add your answer
Q3. Salary related or other.
Add your answer

Simple 30-question 30-minute general aptitude test (entry-level)

Q1. General discussion about projects created. Tech stack selection and other project related questions
Add your answer

Q1. SQL queries , python pandas and numpy , power bi related questions
Add your answer

Q1. Previous experience, skills and expertise
Add your answer