Amazon BI Engineer Interview Questions and Answers

3 questions of dsa
1 of api

Q1. Graph based question to find the shortest path between 2 prime numbers by changing 1 digit at once and obtained number should be prime too.
Add your answer

Hackerrank Coding Test, Leetcode medium questions

HLD test, was asked to design an online coding platform like leetcode

Q1. Most interesting project you have worked on
Add your answer
Q2. How do you handle conflict at workplace
Add your answer

Q1. Find the leaves of the tree.
Ans. 
Leaves of a tree are the nodes with no children in a tree data structure.
• Traverse the tree and identify nodes with no children.

• Use depth-first search or breadth-first search algorithms to find leaves.

• Examples: In a binary tree, leaves are nodes with no left or right child.

• In a general tree, leaves are nodes with no children in their child list.
Answered by AI
Add your answer
Q2. Find the LCA of tree.
Ans. 
The Lowest Common Ancestor (LCA) of a tree is the shared ancestor of two nodes farthest from the root.
• Start from the root and traverse the tree to find the paths from the root to the two nodes.

• Compare the paths to find the last common node between them, which is the LCA.

• If one of the nodes is an ancestor of the other, then the ancestor node is the LCA.
Answered by AI
Add your answer

Q1. What projects you worked upon?
Ans. 
I have worked on projects involving web development, mobile app development, and data analysis.
• Developed a web application using React and Node.js for a client in the e-commerce industry

• Created a mobile app using Flutter for a startup in the healthcare sector

• Performed data analysis on customer behavior using Python and SQL for a marketing company
Answered by AI
Add your answer
Q2. What internships you did?
Ans. 
I completed internships at ABC Company and XYZ Company during my undergraduate studies.
• Interned at ABC Company working on web development projects

• Interned at XYZ Company assisting with software testing and quality assurance

• Gained hands-on experience in coding, debugging, and problem-solving
Answered by AI
Add your answer

Some database questions,some java questions .

Q1. What is the difference between javascript and jQuery.
Ans. 
JavaScript is a programming language used for web development, while jQuery is a library built with JavaScript to simplify HTML document traversal and manipulation.
• JavaScript is a programming language, while jQuery is a library written in JavaScript.

• JavaScript can be used for a wide range of tasks, while jQuery is mainly used for DOM manipulation and event handling.

• JavaScript is a core technology for web development, w...read more
Answered by AI
Add your answer
Q2. Define different types of join
Ans. 
Different types of joins are used in SQL to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is at least one match in both tables.

• Left Join (or Left Outer Join): Returns all rows from the left table and the matched rows from the right table.

• Right Join (or Right Outer Join): Returns all rows from the right table and the matched rows from the left table.

• Full ...read more
Answered by AI
Add your answer
Q3. Define multithreading concept and exception handling.
Ans. 
Multithreading allows multiple threads to run concurrently, while exception handling deals with errors in a program.
• Multithreading involves running multiple threads simultaneously to improve performance and responsiveness.

• Threads share the same memory space but have their own program counter and registers.

• Exception handling is a mechanism to handle errors or exceptional situations in a program.

• It helps prevent the prog...read more
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer

Got a leetcode easy question

If the cost price of an item is Rs. 150 and the selling price is Rs. 200, what is the profit percentage?

Q1. What is the difference between a stack and a queue? Give an example where you would use each.
Ans. 
A stack is a LIFO data structure while a queue is a FIFO data structure.
• Stack: Last In First Out (LIFO), used in undo/redo functionality, backtracking, and recursion.

• Queue: First In First Out (FIFO), used in job scheduling, breadth-first search, and printing.

• Stack uses push() and pop() operations while queue uses enqueue() and dequeue() operations.
Answered by AI
View 5 more answers
Q2. What is the difference between a compiler and an interpreter?
Ans. 
A compiler translates the entire program into machine code before execution, while an interpreter translates and executes the program line by line.
• A compiler converts the source code into an executable file, while an interpreter executes the code directly.

• Compilers typically produce faster and more efficient code, while interpreters provide faster development and debugging.

• Examples of compilers include GCC, Clang, and ...read more
Answered by AI
View 2 more answers
Q3. A compiler is a program that translates the entire source code into machine code before executing it. The source code is fed into the compiler, which analyzes and translates it into an executable file. Thi...read more
Add your answer

Q1. How do you handle stress and pressure?
Ans. 
I handle stress and pressure by practicing time management, seeking support from colleagues, and maintaining a healthy work-life balance.
• I prioritize tasks and create a schedule to manage my time effectively.

• I communicate with my team and seek their assistance or guidance when needed.

• I engage in stress-relieving activities outside of work, such as exercising or spending time with loved ones.

• I practice mindfulness and d...read more
Answered by AI
View 5 more answers

Online assessment, leet code easy

Live coding assessment, leet code medium

Behavioral asking on past experience