Advisor360° Interview Questions and Answers

Sql mcq questions with medium difficulty

Q1. What is inheritance? What are advantages of oops? What's indexing in sql?
Add your answer

Q1. What was your previous job role? What methodologies did you follow while working?
Add your answer

Q1. What are you leaving your current organization?
Add your answer

Hacker Rack Test with medium to high difficulty

Q1. Explain your current project
Ans. 
I am currently working on developing a mobile application for tracking fitness goals and progress.
• Developing a mobile app using React Native

• Implementing features such as goal setting, progress tracking, and workout logging

• Integrating with wearable devices like Fitbit for data synchronization
Answered by AI
Add your answer
Q2. Questions about kakfa, ES and Java 8
Add your answer

Q1. Similar questions on your current project and questions around kafka
Add your answer

Basic Coding Java and algorithm questions

Q1. Create basic react app with dummy data fetched from JSON API
Ans. 
Create a basic React app with dummy data fetched from a JSON API.
• Set up a new React project using create-react-app

• Create a component to fetch data from a JSON API using fetch or axios

• Display the fetched data in the component
Answered by AI
Add your answer
Q2. Array methods and Flatten array
Add your answer
Q3. Event loop
Add your answer
Q4. HTML and Javascript basics
Add your answer

Q1. Roles and responsibilities
Add your answer
Q2. Problem based questions
Add your answer
Q3. Code test & discussions over best practices, best solutions, time and space complexities
Add your answer

Q1. What data structure is used to implement a priority queue?
Ans. 
Binary heap is used to implement a priority queue.
• Binary heap is a complete binary tree where each node has a value greater than or equal to its children.

• It can be implemented using arrays, where the parent of node at index i is at index (i-1)/2.

• Insertion and deletion operations have time complexity of O(log n) in a binary heap.
Answered by AI
Add your answer
Q2. How many trees will a binary tree have?
Ans. 
A binary tree can have any number of nodes, but the maximum number of trees with n nodes is 2^n.
• A binary tree can have 0 nodes, 1 node, 2 nodes, or any number of nodes.

• The maximum number of binary trees with n nodes is 2^n.

• For example, a binary tree with 3 nodes can have up to 8 different structures.
Answered by AI
Add your answer

Q1. SQL Query to return the second highest marks in a student database
Ans. 
Use a SQL query to find the second highest marks in a student database.
• Use the ORDER BY clause to sort the marks in descending order

• Use the LIMIT clause to limit the result to the second row
Answered by AI
Add your answer
Q2. Program to check if two strings are anagrams
Ans. 
Program to check if two strings are anagrams
• Create a function that takes in two strings as input

• Remove any spaces and convert both strings to lowercase for consistency

• Sort the characters in both strings and compare if they are equal to determine if they are anagrams

• Example: 'listen' and 'silent' are anagrams
Answered by AI
Add your answer

A link was provided for the 15-minute online aptitude test.

90 minutes coding round. There were three problems. One for JavaScript and two for ReactJS

Q1. Mostly ReactJS questions were asked and a few Javascript questions were asked.
Add your answer

Q1. Again a few react based questions then it was mostly discussion on the past experiences.
Add your answer

Q1. A general discussion about the notice period, compensation, and information about the company's culture was provided.
Add your answer

Q1. Introducing your self and project
Add your answer
Q2. Severity and priority
Add your answer
Q3. Smoke and sanity testing
Add your answer
Q4. Scenario base question if find bug before release
Add your answer

Q1. Simple travel question
Add your answer
Q2. Simple reply and Selection
Add your answer
Q3. Good job at any cost
Add your answer
Q4. I want top most Salary
Add your answer
Q5. I need good appreciation
Add your answer