AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
ffreedom app
Compare
Filter interviews by
ffreedom app Data Science Intern Interview Questions and Answers
ffreedom app Data Science Intern Interview Experiences
1 interview found
Anonymous
Selected
I applied via LinkedIn and was interviewed before Jan 2024. There was 1 interview round.
(2 Questions)
- Q1. What is the SQL query for calculating a moving average?
- Ans.
The SQL query for calculating a moving average involves using window functions.
Use the OVER clause with the ORDER BY clause to define the window frame for the moving average calculation.
Use the AVG() function to calculate the average within the window frame.
Example: SELECT value, AVG(value) OVER (ORDER BY date ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS moving_avg FROM table_name;
- Q2. What is the difference between Data Definition Language (DDL) and Data Manipulation Language (DML)?
- Ans.
DDL is used to define the structure of database objects, while DML is used to manipulate data within those objects.
DDL is used to create, modify, and delete database objects such as tables, indexes, and views.
DML is used to insert, update, retrieve, and delete data within those database objects.
Examples of DDL statements include CREATE TABLE, ALTER INDEX, and DROP VIEW.
Examples of DML statements include INSERT INTO, UP
Interview Preparation Tips
- MySQL
Top trending discussions
Interview questions from similar companies
I applied via Campus Placement and was interviewed in Oct 2024. There was 1 interview round.
5 dsa questions and 5 aptitude questions given. DSA were of medium to hard based on dp
Selected
I applied via Company Website and was interviewed before Dec 2023. There were 3 interview rounds.
Categories of the CAT exam include Quantitative Aptitude, Verbal Ability, Data Interpretation and Logical Reasoning, and Graphical questions.
Medium level. Focus on SQL subqueries application.
(2 Questions)
- Q1. Statistical questions related to different hypothesis testing
- Q2. Questions related to different machine learning model
I was interviewed in Dec 2021.
Round duration - 60 minutes
Round difficulty - Easy
Timing: 8:00-9:00 PM
There was 1 MCQ and 3 SQL queries. The platform was easy to use and navigate.
Round duration - 30 minutes
Round difficulty - Medium
Timing: 11 AM-11:30 AM
The interviewer was very kind and helpful. He helped me by giving hints whenever I was stuck.
(1 Question)
Round duration - 30 minutes
Round difficulty - Medium
Timing: 12:15 PM to 12:45 PM.
The interviewer was very helpful and friendly. He was more interested in my approach rather than the final answer.
- Q1. What new feature would you like to add to Uber?
Round duration - 30 minutes
Round difficulty - Hard
Timing: 3:00PM to 3:30PM
This was Hiring Manager round. He asked me case study type of questions.
Interview Preparation Tips
Tip 1 : Practice SQL and python coding questions using online coding platforms.
Tip 2 : Get in-depth theoretical knowledge about all the machine learning algorithms.
Tip 3 : Strengthen your statistics understanding.
Tip 1 : Highlight your skills properly
Tip 2 : Have thorough understanding about everything written in the resume
Anubhav Kesari
(3 Questions)
- Q1. Questions on Past Project
- Q2. SQL Dense Rank - also having the option to do in Pandas
- Q3. Pandas groupby on a dataset given - required to calculate group wise yoy rate of a column
(2 Questions)
- Q1. Past project ( which he chose , he chose my very first project , which I had forgotten) so ended up screwing it
- Q2. SQL / Pyspark question - difficult question
(2 Questions)
- Q1. Tell me about your projects?
- Q2. How do you approach the project if you are using logistic regression model?
- Ans.
Approach involves data preprocessing, model training, evaluation, and interpretation.
Perform data preprocessing such as handling missing values, encoding categorical variables, and scaling features.
Split the data into training and testing sets.
Train the logistic regression model on the training data.
Evaluate the model using metrics like accuracy, precision, recall, and F1 score.
Interpret the model coefficients to under...
(2 Questions)
- Q1. What are you future goals?
- Q2. What would you do if your interested field doesnt have any work in the company?
- Ans.
I would seek opportunities to apply my skills in related fields within the company.
Explore other departments or teams within the company that may have projects related to my field of interest
Offer to collaborate with colleagues in different departments to bring a new perspective to their projects
Seek out professional development opportunities to expand my skills and knowledge in related areas
Skills evaluated in this interview
I applied via Company Website and was interviewed in Dec 2024. There was 1 interview round.
Easy topics arrays, sequence sum.
(2 Questions)
- Q1. Explain TFIDF and explain CNN
- Ans.
TFIDF is a technique to quantify the importance of a word in a document. CNN is a deep learning algorithm commonly used for image recognition.
TFIDF stands for Term Frequency-Inverse Document Frequency and is used to evaluate the importance of a word in a document relative to a collection of documents.
TFIDF is calculated by multiplying the term frequency (number of times a word appears in a document) by the inverse docu...
- Q2. Mysql window functions and exceute same in pandas
- Ans.
Window functions in MySQL and pandas are used for performing calculations across a set of rows related to the current row.
In MySQL, window functions can be used with OVER() clause to perform calculations like ranking, cumulative sum, moving average, etc.
In pandas, window functions can be applied using the rolling() and expanding() methods to calculate statistics over a specified window of rows.
Example: In MySQL, to cal...
Interview Preparation Tips
Skills evaluated in this interview
Write a script to print a python for loop
Interview Preparation Tips
I applied via Referral and was interviewed in Sep 2023. There was 1 interview round.
(1 Question)
- Q1. Asked firstly some question over my resume then 2 case study type problems where i have to improve the recommdation system for zomato, and finally one coding question based on two pointer
ffreedom app Interview FAQs
Tell us how to improve this page.
ffreedom app Interviews By Designations
- ffreedom app Relationship Manager Interview Questions
- ffreedom app Customer Relationship Manager Interview Questions
- ffreedom app Relationship Officer Interview Questions
- ffreedom app Team Lead Interview Questions
- ffreedom app Anchor Interview Questions
- ffreedom app Asm Assistant Interview Questions
- ffreedom app Associate Bancassurance Sales Manager Interview Questions
- ffreedom app Associate Sales Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Scientist Interview Questions
- Data Science Engineer Interview Questions
- Senior Data Scientist Interview Questions
- Data Science Consultant Interview Questions
- Jr. Data Scientist Interview Questions
- Decision Scientist Interview Questions
- Associate Data Scientist Interview Questions
- Data Scientist Intern Interview Questions
- Show more
ffreedom app Data Science Intern Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Relationship Manager
340
salaries
|  ₹0.8 L/yr - ₹6 L/yr |
|
Team Lead
149
salaries
| ₹2 L/yr - ₹4.5 L/yr |
|
Associate Sales Manager
81
salaries
| ₹2 L/yr - ₹4.5 L/yr |
|
Assistant Manager
46
salaries
| ₹3.5 L/yr - ₹7 L/yr |
|
Financial Advisor
25
salaries
| ₹1.1 L/yr - ₹2.5 L/yr |
Swiggy
Zomato
Ola Cabs
Uber
- Home >
- Interviews >
- ffreedom app Interview Questions >
- ffreedom app Data Science Intern Interview Questions
