i
Mio Design
Filter interviews by
I applied via Approached by Company and was interviewed before Jan 2022. There were 2 interview rounds.
I applied via Campus Placement and was interviewed in Jul 2020. There were 5 interview rounds.
I applied via LinkedIn and was interviewed before Aug 2023. There were 2 interview rounds.
Union combines and removes duplicates, Union All combines without removing duplicates.
Union combines result sets and removes duplicates
Union All combines result sets without removing duplicates
Union is slower than Union All as it involves removing duplicates
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;
Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;
To show top 5 in pandas, use the nlargest() function.
Use the nlargest() function with the 'n' parameter set to 5 to get the top 5 values in a pandas DataFrame.
For example: df['column_name'].nlargest(5) will return the top 5 values in the specified column.
A scatter plot is a better representation for 3 numerical columns.
Use a scatter plot to show the relationship between the numerical columns.
Scatter plots are effective for visualizing correlations and patterns in data.
Each point on the plot represents a data point with values from all 3 columns.
Easy leetcode data structure question
Code for calling a REST API and designing a rate limiter
Use a library like requests or axios to make the API call
Implement a token bucket algorithm for rate limiting
Set a maximum number of requests per second and queue excess requests
Consider using a distributed rate limiter for scalability
Design a database schema for Instagram.
Create tables for users, posts, comments, likes, and follows.
Use primary and foreign keys to establish relationships between tables.
Store user data such as username, email, and password securely.
Include fields for post content, location, and timestamp.
Track likes and comments on posts.
Implement a notification system for follows and likes.
Consider scalability and performance in the...
I applied via Recruitment Consultant and was interviewed in Dec 2021. There were 3 interview rounds.
Ad network is a platform that connects advertisers with publishers to display ads. Ad exchange is a marketplace for buying and selling ad inventory.
Ad network connects advertisers with publishers to display ads
Ad exchange is a marketplace for buying and selling ad inventory
Ad network typically charges a commission on ad spend
Ad exchange uses real-time bidding to determine the price of ad inventory
Examples of ad network...
posted on 22 Sep 2024
I applied via LinkedIn and was interviewed before Sep 2023. There was 1 interview round.
Managed project to implement new inventory system and led team in redesigning customer service process.
Implemented new inventory system to streamline operations
Led team in redesigning customer service process to improve efficiency
Successfully managed project timelines and budgets
Collaborated with cross-functional teams to ensure project success
posted on 26 Jul 2022
I applied via Company Website and was interviewed in Jun 2022. There were 2 interview rounds.
HTML, HTML5 ,CSS , Bootstrap, javaScript
posted on 14 Feb 2024
I was interviewed in Aug 2023.
First there was aptitude round
The coding question was average level
To create an external tab link, use HTML anchor tag with target attribute set to _blank.
Use <a> tag in HTML with href attribute pointing to the external link
Set the target attribute of the <a> tag to _blank to open the link in a new tab
Example: <a href='https://www.example.com' target='_blank'>External Link</a>
based on 1 interview
Interview experience
based on 18 reviews
Rating in categories
Graphic Designer
4
salaries
| ₹0 L/yr - ₹0 L/yr |
Copywriter
4
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Visualiser
4
salaries
| ₹0 L/yr - ₹0 L/yr |
ART Director
4
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Business Manager
4
salaries
| ₹0 L/yr - ₹0 L/yr |
Omnicom Media Group
Z1 Tech
7Search PPC
Bikayi