Xoriant Internship Trainee Interview Questions and Answers

Basic questions on oops and sql queries

Q1. SQL Query on many to many table and aggregations
Add your answer
Q2. OOPS concepts and SpringBoot
Add your answer

Q1. Let us assume we have an array of 0's and 1's,how would you find the first index for 1.
Ans. 
Iterate through the array and return the index of the first occurrence of 1.
• Iterate through the array using a loop.

• Check each element of the array, if it is 1 then return its index.

• If no 1 is found, return -1.
Answered by AI
Add your answer
Q2. SQL queries related to Order By and Group By
Add your answer

Could be random topic from current trends to be discussed with 10 to 30 people at the same time give as much input you can

Same as the first round but this time you will be given time to prepare for the topic and the topics are very limited again put as input you can

This is for logical reasoning and verbal ability its easy to medium round you can pass it

1hr topics:c,c++,java,dbms,psuedo-code

Group of 8 in campus:15min:Post covid times

Q1. Write a dbms query i.
Ans. 
A dbms query i was asked to write for Engineer Trainee position.
• Specify the table name and columns to be selected

• Use WHERE clause to filter the data

• Use JOIN to combine data from multiple tables

• Use GROUP BY to group data based on a column

• Use ORDER BY to sort the data in ascending or descending order
Answered by AI
Add your answer
Q2. Explain OPPS concept in c++
Ans. 
OPPS is a programming paradigm that focuses on objects and their interactions to solve problems.
• OPPS stands for Object-Oriented Programming System

• It involves the use of classes, objects, inheritance, polymorphism, and encapsulation

• C++ is an object-oriented programming language that supports OPPS

• Example: A car can be represented as an object with properties like color, model, and methods like start, stop, and accelerate
Answered by AI
Add your answer
Q3. Explain about project done along with your role in the project
Add your answer
Q4. Explain about internship done
Add your answer

Q1. Self introduction
Add your answer

Aptitudes and reasoning

Q1. What is inheritance in java
Ans. 
Inheritance in Java allows a class to inherit properties and behavior from another class.
• Inheritance enables code reusability and promotes the concept of hierarchical classification.

• Subclasses can access the methods and fields of their superclass.

• Example: class Dog extends Animal, where Dog inherits properties and behaviors from Animal class.
Answered by AI
Add your answer
Q2. What is collection
Ans. 
Collection refers to the act of gathering or bringing together a group of items or objects.
• Collection can refer to the act of gathering items or objects for a specific purpose.

• Collections can include items such as art pieces, stamps, coins, or books.

• Collections can also refer to the process of gathering data or information for analysis or research.

• Collections can be personal hobbies or professional pursuits.

• Collections...read more
Answered by AI
Add your answer

Q1. Project experience
Ans. 
I have worked on multiple projects during my time in university, including a group project on developing a mobile application.
• Developed a mobile application for a group project

• Collaborated with team members to design and implement features

• Tested the application for bugs and user experience

• Presented the project to professors and peers for evaluation
Answered by AI
Add your answer
Q2. Behavioural question
Add your answer