Magic9 Media and Analytics Summer Intern Interview Questions and Answers

Well rounded coding test testing knowledge

Q1. Design system netflix features
Ans. 
Designing a system for Netflix features involves creating a user-friendly interface with personalized recommendations and seamless streaming capabilities.
• Implement a recommendation algorithm to suggest content based on user preferences and viewing history

• Include a user-friendly interface with easy navigation and search functionality

• Ensure seamless streaming capabilities with minimal buffering times and high video quali...read more
Answered by AI
Add your answer

Q1. Great interview system
Add your answer
Q2. How to maniputalte data
Ans. 
Data manipulation involves changing, organizing, or analyzing data to derive insights or achieve specific goals.
• Use software tools like Excel, Python, or SQL to manipulate data

• Filter, sort, and clean data to remove errors or inconsistencies

• Perform calculations, transformations, or aggregations on the data

• Join datasets together to create new insights

• Visualize data using charts or graphs to better understand patterns
Answered by AI
Add your answer

Ds har dleet code problems

Design appple mobile device

The online coding round was conducted on SHL. It was for 1 hour 3 questions. Topics were basic DSA concepts.

Q1. Difference between c and cpp
Ans. 
C is a procedural programming language while C++ is an object-oriented programming language.
• C does not support classes and objects, while C++ does.

• C uses structures for data organization, while C++ uses classes.

• C allows direct memory manipulation, while C++ provides features like inheritance and polymorphism.

• C++ has additional features like templates and exception handling that are not present in C.
Answered by AI
Add your answer
Q2. Explain projects
Ans. 
Projects are tasks or assignments that require a specific goal or outcome to be achieved within a set timeframe.
• Projects involve planning, execution, and monitoring of tasks to achieve a specific goal.

• They often have a defined scope, budget, and timeline.

• Examples include developing a new software application, organizing a marketing campaign, or conducting a research study.
Answered by AI
Add your answer
Q3. Questions were asked on oops, computer networks, software engineering
Add your answer

Q1. Sql queries of dbms
Ans. 
SQL queries are used to retrieve, update, and manipulate data in a database management system.
• Use SELECT statement to retrieve data from a table

• Use INSERT statement to add new data to a table

• Use UPDATE statement to modify existing data in a table

• Use DELETE statement to remove data from a table

• Use JOIN statement to combine data from multiple tables
Answered by AI
Add your answer
Q2. In depth dbms and oops
Add your answer

Q1. Challenges faced while making projects
Add your answer
Q2. Tell about your family
Add your answer

30 MCQ questions and 2 coding question

Q1. Questions related to DBMS sql queries oops and java was asked.
Add your answer
Q2. Resume based questions , project questions.
Add your answer

It was a Pymetrics test followed by MCQ situation based questions

It was Coding round of 2 Questions on Hackerrank

Q1. Questions on Binary trees ,2-D DP and Linked List
Add your answer

Q1. Why standard chartered
Add your answer

The basic stuff they usually ask

Web based coding Test in python

Excel and PPT shortcuts, CN, Pseudocodes etc.

Q1. Project details
Add your answer

Q1. Who are you today
Ans. 
I am a motivated and ambitious individual with a passion for learning and growth.
• Motivated and ambitious

• Passionate about learning and growth

• Driven to succeed

• Open to new challenges and experiences
Answered by AI
Add your answer
Q2. What is the nature of Google as a company?
Ans. 
Google is a multinational technology company known for its search engine, advertising platform, and various other products and services.
• Google is known for its innovative products and services such as Google Search, Google Maps, Gmail, and YouTube.

• The company's mission is to organize the world's information and make it universally accessible and useful.

• Google's business model is primarily based on advertising revenue t...read more
Answered by AI
Add your answer