Scaler by InterviewBit Interview Questions and Answers

It was Easy to Medium level questions for anyone with aptitude skills.
In my college out of 2500 students, only 45 students were selected for the second round in which we got TAKE HOME ASSIGNMENTS.

The second Round is Take Home Assignment which is a Case Study: I have got Case Study on RIDE HAILING Startup I have to make a 5 Minutes video that includes my introduction, Why I want to be APM ? and last root cause analysis on any startup or product.

Student and mentor type of assignment was needed

Q1. CTO asked cultural type of questions
Add your answer
Q2. Why use a library and if not then why use a polyfill
Ans. 
Libraries provide pre-written code for common tasks, while polyfills fill in missing browser functionality.
• Libraries save time by providing pre-written code for common tasks

• Polyfills fill in missing browser functionality for older browsers

• Libraries can improve code readability and maintainability

• Polyfills can help ensure consistent behavior across different browsers

• Using libraries and polyfills can help developers focu...read more
Answered by AI
Add your answer

A case study on ride hailing app losing amount, analysis and recommendations should be made

Q1. Nesting of the table values
Ans. 
Nesting of table values refers to storing tables within other tables to create a hierarchical structure.
• Nesting allows for organizing data in a structured manner

• It can help in reducing redundancy and improving data retrieval efficiency

• Example: A table of employees can have a nested table of projects assigned to each employee
Answered by AI
Add your answer
Q2. Finding out aggregate values
Ans. 
Aggregate values are calculated by combining multiple values into a single result, such as sum, average, count, etc.
• Aggregate functions are commonly used in SQL queries to perform calculations on groups of rows

• Examples of aggregate functions include SUM, AVG, COUNT, MIN, MAX

• Aggregate values can provide insights into overall trends and patterns in data
Answered by AI
Add your answer
Q3. Difference between like and =
Ans. 
The difference between 'like' and '=' is that 'like' is used for pattern matching in SQL queries, while '=' is used for exact matching.
• LIKE is used in SQL for pattern matching, while = is used for exact matching

• LIKE is case-insensitive by default, while = is case-sensitive

• LIKE can use wildcard characters such as % and _, while = cannot
Answered by AI
Add your answer

Q1. Try to be real and fluent while speaking
Add your answer
Q2. WIll ask about your previous experrience
Add your answer