Advisor360° Interview Questions and Answers

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. 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

Normal basic question train and few Logic

Q1. What is Continue?
Ans. 
Continue is a keyword in programming that is used to skip the current iteration of a loop and continue with the next iteration.
• Continue is used in loops like for, while, and do-while to skip the current iteration and move to the next one.

• It is often used to skip certain elements in an array or to avoid executing specific code under certain conditions.

• Example: for(int i=0; i<5; i++) { if(i==2) { continue; } System.out.p
Answered by AI
Add your answer
Q2. Break, if else, while
Add your answer

Q1. How Performance of application can be improved
Ans. 
Performance of an application can be improved by optimizing code, using efficient algorithms, caching data, and scaling resources.
• Optimize code by reducing unnecessary loops, improving database queries, and minimizing memory usage

• Use efficient algorithms like binary search instead of linear search for large datasets

• Implement caching mechanisms to store frequently accessed data and reduce database calls

• Scale resources b...read more
Answered by AI
Add your answer

Q1. SQL Questions - Constraints- how to optimize long SQL query without changing the output
Add your answer

Q1. Define your current role and responsibilities
Add your answer
Q2. Process of requirement gathering
Ans. 
Requirement gathering is the process of collecting and documenting information from stakeholders to define project needs.
• Identify stakeholders and gather their input

• Document requirements in a clear and organized manner

• Validate requirements with stakeholders to ensure accuracy

• Use techniques like interviews, surveys, and workshops to gather information
Answered by AI
Add your answer
Q3. Steps of initiating a new project
Add your answer
Q4. How do you manage stakeholders
Add your answer
Q5. Scrum Artifacts
Add your answer

Q1. Current role and responsibilities
Add your answer
Q2. Artifacts for developer
Ans. 
Artifacts for developers include design documents, code repositories, test cases, and deployment scripts.
• Design documents such as architecture diagrams and wireframes

• Code repositories like GitHub or Bitbucket for version control

• Test cases to ensure code functionality and quality

• Deployment scripts for automating the deployment process
Answered by AI
Add your answer
Q3. Process models, ERD, Use cases
Add your answer

It was Machine test, i had to make a project and connect it to Database and submit details in database table from form.

Q1. Technical verbal Interview, question were related to JavaScript, Json, JQuery, and how to perform click and other event on click, on change etc, and how to get text content entered in text box, mostly rel...read more
Add your answer
Q2. What is Collection Framework?
Ans. 
Collection Framework is a unified architecture for representing and manipulating collections of objects in Java.
• It provides interfaces (List, Set, Queue, etc.) and classes (ArrayList, HashSet, PriorityQueue, etc.) to store and manipulate groups of objects.

• Collections can be easily sorted, searched, and iterated using methods provided by the Collection Framework.

• Example: ArrayList is a class that implements the List int...read more
Answered by AI
Add your answer
Q3. What is RestApi?
Ans. 
RestApi is a set of rules and conventions for building and interacting with web services using HTTP methods.
• RestApi stands for Representational State Transfer Application Programming Interface.

• It allows communication between different software systems over the internet.

• RestApi uses standard HTTP methods like GET, POST, PUT, DELETE for data manipulation.

• JSON or XML formats are commonly used for data exchange in RestApi.

• ...read more
Answered by AI
Add your answer
Q4. How to add one ArrayList object to another, which method is used to achieve this. Ans:- By using addAll() Method

Ans. 

The addAll() method is used to add all elements of one ArrayList to another.

• Use the addAll() method to add all elements of one ArrayList to another

• Syntax: list1.addAll(list2);

• Example: ArrayList list1 = new ArrayList<>(); list1.addAll(Arrays.asList(1, 2, 3));

Add your answer