Yotta Infrastructure Solutions Graduate Trainee Interview Questions and Answers

Q1. Sql questions, joins, primary key, foreign key. Inner queries
Add your answer
Q2. Core Java questions
Add your answer

SQL questions and query output.

Q1. I had interview on SQL and pl SQL. So the interview started with basic sql questions and then level increased. Question were asked on joins, union, rank, dense rank. Indexes, triggers. I was asked to ri...read more
Add your answer

Round duration - 60 minutes
Round difficulty - Medium

Q1. How would you design a web page that integrates charts with an API and retrieves data stored in a database?
Ans. 
Design a web page integrating charts with an API to retrieve data from a database.
• Use a front-end library like Chart.js to create interactive charts on the web page.

• Implement a back-end API using a framework like Node.js or Django to fetch data from the database.

• Connect the front-end charts to the back-end API using AJAX or fetch requests.

• Ensure proper authentication and authorization mechanisms to access the database
Answered by AI
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

Q1. 
Sort an Array of 0s and 1s
Sort an array that contains only 0s and 1s, ensuring that the array is traversed only once to achieve the sorting.
Input:
T = number of test cases
N = size of the array for eac...read more
Ans. 
Use two pointers approach to traverse the array and swap 0s and 1s to achieve sorting in place.
• Initialize two pointers, one at the beginning and one at the end of the array.

• Move the left pointer until it encounters a 1, and move the right pointer until it encounters a 0.

• Swap the elements at the left and right pointers, and continue this process until the pointers meet.

• The array will be sorted with 0s on the left and 1s
Answered by AI
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

Normal hr questions