AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
YNRS Business Solutions
Compare
Filter interviews by
YNRS Business Solutions Interview Questions and Answers
Be the first one to contribute and help others!
Interview questions from similar companies
I was interviewed in Apr 2020.
Interview Questionnaire
4 Questions
- Q1. Explain the most challenging problem you faced at work
- Q2. Given the following design - A university has colleges, colleges have departments, departments have students. There are department level elections being held where students nominate themselves to stand fo...
- Ans.
Design a database for a university with colleges, departments, and students. Write a query to get students with maximum votes.
Use a relational database like MySQL or PostgreSQL
Create tables for colleges, departments, students, and elections
Use foreign keys to establish relationships between tables
Add columns for election details like candidate names and vote counts
Write a query to join tables and filter for maximum vot
- Q3. Explain how you would design a bit.ly URL shortening service. What would be the choice of database. What would be your table design what would be the endpoints
- Ans.
Design a bit.ly URL shortening service with database choice, table design, and endpoints.
Use a relational database like MySQL or PostgreSQL for scalability and ACID compliance.
Create a table with columns for the original URL, shortened URL, and metadata like creation date and click count.
Endpoints should include URL shortening, redirection, and analytics.
Implement caching to improve performance and reduce database load...
- Q4. Coding test - knapsack problem, 2 sum problem, alien language problem. All from leetcode.
Interview Preparation Tips
Read or watch system design questions explained on Youtube.
Skills evaluated in this interview
(2 Questions)
- Q1. Describe your current project
- Q2. Why do you want to change?
Create a hero section for website
Online test with basic questions along with c++ question
Virtual group discussion
Software Developer Interview Questions & Answers
Panorbit Services LLP
Anonymous
posted on 22 Sep 2024
Selected
Desgining of backend services
There was a data with some 6000 rows and we have to derive 5 useful insights from it
To know yourself like it was a kind of OPQ
(1 Question)
- Q1. Tjere was a questions on what is data analysis,how we do it,wep scrapper ,data crawling
(1 Question)
- Q1. It was a discussion with CEO of company
Interview Preparation Tips
Selected
I applied via Company Website and was interviewed before Oct 2023. There were 2 interview rounds.
(1 Question)
- Q1. It was basic data analyst non technical quesions
(1 Question)
- Q1. Salary Discussion
Selected
I applied via Recruitment Consulltant and was interviewed before Sep 2022. There were 3 interview rounds.
It was a simple case study with a regression problem
(4 Questions)
- Q1. The interview was focused on basics of data analytics and python.
- Q2. What is the imp stw in data analytics?
- Ans.
The importance of data analytics lies in its ability to help organizations make informed decisions, identify trends, and improve overall performance.
Data analytics helps organizations make data-driven decisions
It allows businesses to identify trends and patterns in data
Data analytics can improve operational efficiency and performance
It enables organizations to gain insights and make predictions based on data
Data analyt...
- Q3. What is rank and dense rank
- Ans.
Rank and dense rank are functions used in SQL to assign a rank to each row based on a specified column.
Rank function assigns a unique rank to each distinct row based on the specified column.
Dense rank function assigns a unique rank to each distinct row based on the specified column, but does not leave gaps between ranks.
Example: If we have a table of students with their scores, using rank function will assign ranks lik...
- Q4. Advanced excel formulas were asked
Skills evaluated in this interview
They will provide you with dataset and we need to find insights from that
(1 Question)
- Q1. Why do want to join as a data analyst
- Ans.
I am passionate about uncovering insights from data and using them to drive informed decision-making.
I have a strong background in statistics and data analysis
I enjoy working with large datasets and finding patterns within them
I am excited about the opportunity to make a meaningful impact through data-driven decision-making
I am proficient in data visualization tools like Tableau and Power BI
2 ( 1 medium + 1 hard ) coding questions , 2 ( 1 medium + 1 easy ) sql questions, 10 MCQS( os, cn, dbms, aptitude ).
(1 Question)
- Q1. 1 easy coding and design problem on how would you design a web app like book my show.
Interview Preparation Tips
Tell us how to improve this page.
Interview Questions for Popular Designations
Interview Questions from Similar Companies
YNRS Business Solutions Reviews and Ratings
based on 1 review
Rating in categories
GrapplTech
Rialtes Technologies
Wilco Source
TraviYo
- Home >
- Interviews >
- YNRS Business Solutions Interview Questions
