Write a query to use the aggregate function (any aggregate function)
Trainee Software Engineer Interview Questions
6,035 trainee software engineer interview questions shared by candidates
Walk us with your resume.
1. Online Assessment Aptitude and coding MCQS on C++, Java , .NET , SQL 2. Pre-HR Basic screening and resume discussion. Family background, programming languages I know, and discussion on projects. 3. Technical-1 Core concepts and problem-solving. Project-based SQL questions: table structure and their relation. How to store multiple mobile numbers. Concepts: normalization, GROUP BY, difference between UNIQUE and PRIMARY KEY, WHERE vs HAVING, UNION vs UNION ALL. Definitions and queries on: subquery, foreign key, LIKE, joins, IS NULL, composite primary key, ON DELETE CASCADE, view, window function. Puzzle: Given 3, 5, and 10-liter mugs, fill exactly 10 liters using 4-liter increments. 4. Technical-2 Advanced technical evaluation. Asked to write user flows for both projects. How I would improve and sell them. How I use ChatGPT in daily life. What I understood from the Yardi website. 5. Managerial Scenario-based and team-fit questions. Introduction and deep discussion on each project. Emphasis on my role, development process, and improvements. ( He wrote everything in his notebook ) Given a task: prioritize these – stability, salary, designation, technology, long-term goals, training I gave him the priority List .Asked what my top three would be if God guaranteed them – I answered in the same order (Tip: be yourself). Situation-based question on handling repetitive tasks like in a customer support role. This was the most fun round for me. 6. Final HR Salary, relocation, and final confirmation. Congratulated me. Discussed salary breakdown. Asked if I had other offers. Talked about previous rounds. Discussed training period and structure.
Question on SQL and Advanced SQL
SQL , joins , view , Constraints , etc
Write a query for names starting with c
How to include CSS and Javascript files in your HTML file (Syntax)? SQL Queries Basic to Advance level. What is garbage collection in Java? What is CSS? DBMS Concepts.
Implement stack data structure using array .
Mostly around SQL and little bit of engineering knowledge
easy basic OOP and CRUD API base question.
Viewing 4801 - 4810 interview questions