Infoseek Software Systems Software Developer Trainee Interview Questions and Answers

Basic aptitude, basic math

A group of 10 my topic was technical skills vs soft skills

Q1. Differentiate between Primary key and unique
Ans. 
Primary key uniquely identifies a record in a table, while unique constraint ensures values in a column are unique.
• Primary key is used to uniquely identify each record in a table

• Primary key does not allow NULL values

• Unique constraint ensures that all values in a column are unique

• Unique constraint allows NULL values
Answered by AI
Add your answer
Q2. MySQL commands and questions on them.. then hr questions
Add your answer

Nuts and bolts game, to output date in a certain format, one SQL query

Q1. Stacks and Queues
Add your answer
Q2. Linked lists, arrays, and many more basic fundamental Dsa questions.
Add your answer

Q1. More about your resume projects.
Add your answer
Q2. Puzzles and reasoning is asked
Add your answer

Divisibility, LCM, HCF.
Numbers, Decimals, Fractions, Powers.
Profit, Loss.
Simple interest and Compound interest.
Speed, Distance, Time.
Work and wages.
Trains, Boats, Streams-upstream/downstream, Circular track questions.
Cistern and pipes.

Coding interviews test candidates' technical knowledge, coding ability, problem solving skills, and creativity, typically on a whiteboard.

Choose a topic based on the assignment.
2 Conduct research.
3 Write a thesis statement

Q1. Find in rotated sorted array
Ans. 
Search for a target value in a rotated sorted array.
• Use binary search to find the pivot point where the array is rotated.

• Determine which half of the array the target value lies in based on the pivot point.

• Continue binary search in the appropriate half of the array to find the target value.
Answered by AI
Add your answer
Q2. Design IMDB. how will you manage concurrent ratings
Ans. 
Design IMDB with concurrent ratings management
• Implement a locking mechanism to ensure only one user can update a rating at a time

• Use a queue system to handle multiple rating requests in an orderly manner

• Consider using distributed systems to handle high concurrency levels
Answered by AI
Add your answer

Q1. Design vehicle rental system. Api design
Ans. 
Design a vehicle rental system API
• Create endpoints for listing available vehicles, booking a vehicle, and returning a vehicle

• Include authentication and authorization mechanisms for users and admins

• Implement payment gateway integration for processing rental payments

• Include features like vehicle search, filtering, and reviews/ratings

• Consider scalability and performance optimizations for handling high traffic
Answered by AI
Add your answer

Q1. Promises in javascript
Ans. 
Promises in JavaScript are objects representing the eventual completion or failure of an asynchronous operation.
• Promises are used to handle asynchronous operations in JavaScript.

• They can be in one of three states: pending, fulfilled, or rejected.

• Promises can be chained using .then() to handle success and .catch() to handle errors.
Answered by AI
Add your answer

Basic Js concepts like debouncing,event loop, and other output-based questions.

Q1. Js concepts in depth
Add your answer

Q1. Hiring manager round, questions around my project
Add your answer
Q2. Optimization techniques
Ans. 
Optimization techniques are methods used to improve the efficiency and performance of software applications.
• Use algorithms like greedy, dynamic programming, or divide and conquer to optimize code

• Minimize time complexity by avoiding nested loops and unnecessary iterations

• Utilize data structures like hash tables, arrays, and trees for efficient storage and retrieval

• Profile code to identify bottlenecks and optimize critic...read more
Answered by AI
Add your answer

Q1. They check your knowledge according to job role
Add your answer
Q2. I have prepared python, big data tech, machine learning, cloud.
Add your answer
Q3. They ask about data structure
Add your answer

Q1. Tell me something about past experience.
Add your answer
Q2. About your self
Add your answer

Q1. About ur self some technical problem
Add your answer