Leverage Edu Electrical Engineer Interview Questions and Answers

Q1. The first round was a basic telephonic interview. Then simple basic SQL questions and some question based on Normalisation and DBMS were asked.
Add your answer

Q1. This was the toughest Data Analyst Interview I have faced till now. Interview was of 1 hr. Required higher level of SQL understanding. Asked to share screen and then solve SQL queries. Question based on jo...read more
Add your answer

Q1. Question based on Window Functions in sql
Add your answer
Q2. Order of execution
Ans. 
Order of execution refers to the sequence in which operations are carried out in a program or system.
• Execution starts from the top of the program and moves downwards.

• Operations within parentheses are executed first.

• Multiplication and division are executed before addition and subtraction.

• Functions are executed when they are called.

• Control structures like loops and conditionals affect the order of execution.
Answered by AI
View 1 more answer

Q1. Write a sql query to find out different routes for a airline. Table has two columns which are destination and source
Ans. 
Use a SQL query to find different routes for an airline based on source and destination columns in a table.
• Use a SELECT statement to retrieve the distinct combinations of source and destination.

• Use the DISTINCT keyword to ensure only unique routes are returned.

• Order the results by source and destination for easier analysis.
Answered by AI
View 1 more answer
Q2. Situational questions based on Business KPI
Add your answer

Q1. Simple discussion on the role and company culture
Add your answer

Q1. Case study question
Add your answer

Q1. Basic Discussion on relocation and interest in joining the company.
Add your answer

Q1. Asked about the Statistics concepts hypothesis,pvalue,mean,meadian.mode,normaldistrubution?
Add your answer
Q2. Sql joins questions based on three tables, complex joins
Add your answer

Q1. Technical questions mostly around sql, project based and few theoretical questions on python
Add your answer

Q1. This was one of the most grilled interview i have given, require moderate level of sql understanding, was asked to share screen and solve it , also i had show how it is working then basic questions of py...read more
Add your answer

Q1. Was asked basic HR questions
Add your answer

Q1. What is List comprehension? Print Fibonacci series in python.
Ans. 
List comprehension is a concise way to create lists in Python. Fibonacci series can be printed using list comprehension.
• List comprehension is a compact way to create lists in Python by iterating over an iterable object.

• Fibonacci series can be generated using list comprehension by defining the series logic within the comprehension.

• Example: fibonacci = [0, 1] + [fibonacci[i-1] + fibonacci[i-2] for i in range(2, 10)]
Answered by AI
Add your answer

Q1. You have two table. Employee and salary. Join the table and fetch the 3rd highest salary
Add your answer

Customer segmentation on Sales Data

Q1. Psychological questions
Add your answer

Average question where asked

Normal sql based assignment was there

Q1. Normal question where asked to me
Add your answer

Q1. What's your experience?
Add your answer
Q2. Don't you have Data Science experience?
Ans. 
No, I don't have direct Data Science experience.
• However, I have worked with data extensively in my previous roles as a Data Analyst.

• I have experience in data cleaning, data visualization, and statistical analysis.

• I am also familiar with programming languages such as Python and R, which are commonly used in Data Science.

• I am willing to learn and expand my skills in Data Science if given the opportunity.
Answered by AI
Add your answer

Q1. Typing and speed
Add your answer

Q1. HOW to sell pen
Ans. 
To sell a pen, highlight its features, demonstrate its quality, create a need for it, and offer a competitive price.
• Highlight the unique features of the pen, such as smooth writing, ergonomic design, or special ink technology.

• Demonstrate the quality of the pen by allowing the customer to test it out or showing testimonials from satisfied customers.

• Create a need for the pen by explaining how it can improve the customer'...read more
Answered by AI
Add your answer
Q2. How to do loan
Ans. 
To apply for a loan, one must meet the eligibility criteria, submit required documents, and agree to the terms and conditions.
• Check eligibility criteria such as credit score, income, and employment status

• Gather necessary documents like ID proof, address proof, income proof

• Fill out the loan application form accurately

• Agree to the terms and conditions set by the lender

• Wait for approval or rejection of the loan applicatio
Answered by AI
Add your answer

Q1. Define python and use
Ans. 
Python is a high-level programming language known for its simplicity and readability.
• Python is widely used for data analysis due to its extensive libraries like Pandas and NumPy.

• It is used for data cleaning, manipulation, visualization, and statistical analysis.

• Python can be used to create machine learning models for predictive analytics.

• Python scripts can automate repetitive tasks in data analysis workflows.
Answered by AI
Add your answer
Q2. Define sql an use
Ans. 
SQL is a programming language used for managing and manipulating relational databases.
• SQL stands for Structured Query Language

• Used to retrieve, insert, update, and delete data in databases

• Commonly used commands include SELECT, INSERT, UPDATE, DELETE

• Can be used to create tables, views, and stored procedures
Answered by AI
Add your answer
Q3. Define how to extract data
Ans. 
Extracting data involves retrieving information from various sources and transforming it into a usable format.
• Identify the sources of data such as databases, APIs, files, or websites

• Use tools like SQL queries, Python scripts, or data extraction software to retrieve the data

• Clean and transform the data to remove inconsistencies and prepare it for analysis

• Load the extracted data into a data warehouse or analytical tool f
Answered by AI
Add your answer