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
(1 Question)
- Q1. Asked about the previous job experience and area of interest like frontend or backend
Coding test was on reactjs and html
(1 Question)
- Q1. Asked about all the react concepts in detail
(1 Question)
- Q1. Javascript basics were asked
Software Developer Interview Questions & Answers
Panorbit Services LLP
Anonymous
posted on 22 Sep 2024
Selected
Desgining of backend services
(2 Questions)
- Q1. Describe your current project
- Q2. Why do you want to change?
Selected
I applied via Company Website and was interviewed in Sep 2023. There were 4 interview rounds.
(2 Questions)
- Q1. Education Details
- Q2. Skills, Strength
CRUD Application using Angular
(1 Question)
- Q1. Node.js, OOPs concepts
Praveen Kumar
Usual Leet code problems
System Design Questions
System Design Questions
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
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
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
Mad Street Den
Wilco Source
IDOS INDIA
- Home >
- Interviews >
- YNRS Business Solutions Interview Questions
