GUVI Internship Trainee Interview Questions and Answers

Python technical SQL basic

Q1. Check if string is palindrome
Ans. 
Check if a string is the same forwards and backwards
• Iterate through the string from both ends and compare characters

• Use built-in functions like reverse() to check for palindrome

• Ignore spaces and punctuation when checking for palindrome
Answered by AI
Add your answer

Q1. Question on Binary trees: if symmetric, easy string question using hashmap
Add your answer
Q2. If we are hosting a live test how to show real time ranking, HLD for this and what algorithms can we use
Add your answer

Q1. Database schema design for a feature where user can be free, gold, platinum.
Ans. 
Use a user table with a column for user type (free, gold, platinum)
• Create a user table with columns for user ID, name, email, user type

• Use a separate table for user types with columns for type ID and type name

• Establish a one-to-many relationship between user and user type tables

• Example: user table - user_id, name, email, type_id; user_type table - type_id, type_name
Answered by AI
Add your answer

Q1. HLD for live rank dashboard for a live test where millions of users are doing test
Ans. 
High-level design for a live rank dashboard for a live test with millions of users.
• Use a scalable architecture to handle millions of users concurrently.

• Implement real-time data processing to update ranks dynamically.

• Utilize caching mechanisms to improve performance and reduce load on the database.

• Design a user-friendly interface with intuitive data visualization.

• Include features for filtering, sorting, and searching to
Answered by AI
Add your answer

Q1. What makes you a suitable candidate for this position?
Add your answer
Q2. Where do you envision yourself in five years?
Add your answer

For BDA you have to make video assignment of 4 - 6 minutes with self introduction and answers of 2 question provided you in your whatsapp or mail. After video assignments if you are selected HR department call or whatsapp you personally to invite for Video interaction interview. If interview gone in a right way. They inform you by call or whatsapp message.And finally your training period starts in 2 - 3 days.???? All the Best guys

Q1. Tell me about yourself in english
Add your answer
Q2. How can you convince a college student as career guidance expert
Add your answer

Two dynamic programming challenges at the hard level on LeetCode and 10 medium-level SQL challenge.

Q1. Interduce your self
Ans. 
I am a dedicated and experienced consultant with a strong background in project management and strategic planning.
• Over 10 years of experience in consulting roles

• Specialize in project management and strategic planning

• Proven track record of successful client engagements

• Strong communication and problem-solving skills
Answered by AI
Add your answer
Q2. Work experience
Add your answer

Q1. Interduce your self
Ans. 
I am a dedicated and experienced consultant with a strong background in project management and strategic planning.
• Over 10 years of experience in consulting roles

• Specialize in project management and strategic planning

• Successfully led multiple projects resulting in increased efficiency and cost savings
Answered by AI
Add your answer
Q2. Work experience
Add your answer
Q3. Salary expectance
Add your answer