Intellect Design Arena Graduate Trainee Interview Questions and Answers

Avg level question on aptitude

2 easy or medium level question

Q1. Ragarding oops they asked lot of question like new keyword, template, inheritence , acces modifier, and lot
Add your answer

Q1. They ask situation base dquestion
Add your answer

Easy-moderate question with coding and aptitude

Q1. Questions about microprocessor and the projects done
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

This was a technical round with questions on DBMS.

Q1. What is data integrity?
Ans. 
Data integrity refers to the accuracy, consistency, and reliability of data throughout its lifecycle.
• Data integrity ensures that data is accurate and consistent in storage and transmission.

• It involves maintaining the quality and reliability of data over time.

• Methods for ensuring data integrity include checksums, encryption, and error detection codes.

• Examples of data integrity violations include data corruption, unautho
Answered by AI
Add your answer
Q2. What is a trigger in the context of a database management system?
Ans. 
A trigger is a special type of stored procedure that automatically executes when certain events occur in a database.
• Triggers are used to enforce business rules, maintain data integrity, and automate repetitive tasks.

• They can be triggered by INSERT, UPDATE, or DELETE operations on a table.

• Examples of triggers include auditing changes to a table, updating related tables when a record is modified, or enforcing referential
Answered by AI
Add your answer
Q3. What is the difference between clustered and non-clustered indexes in a database management system?
Ans. 
Clustered indexes physically order the data in the table, while non-clustered indexes do not.
• Clustered indexes determine the physical order of data in the table, while non-clustered indexes do not.

• A table can have only one clustered index, but multiple non-clustered indexes.

• Clustered indexes are faster for retrieval of data, especially range queries, compared to non-clustered indexes.

• Non-clustered indexes are stored se...read more
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Technical interview round with questions on DBMS.

Q1. What is the difference between UNION and UNION ALL in SQL?
Ans. 
UNION combines and removes duplicates, UNION ALL combines without removing duplicates.
• UNION merges the result sets of two or more SELECT statements and removes duplicates.

• UNION ALL merges the result sets of two or more SELECT statements without removing duplicates.

• UNION is slower than UNION ALL as it involves removing duplicates.

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column...read more
Answered by AI
Add your answer
Q2. What are the functions of a cursor in PL/SQL?
Ans. 
A cursor in PL/SQL is used to retrieve and process multiple rows of data one at a time.
• Allows iteration over a result set

• Retrieves data row by row

• Can be used to update or delete rows in a table

• Must be declared, opened, fetched, and closed
Answered by AI
Add your answer
Q3. Write a SQL query to fetch the nth highest salary from a table.
Ans. 
SQL query to fetch the nth highest salary from a table
• Use the ORDER BY clause to sort salaries in descending order

• Use the LIMIT clause to fetch the nth highest salary
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

This was a managerial round with typical behavioral problems.

Round duration - 90 minutes
Round difficulty - Medium

It was Technical + Aptitude MCQ round.The technical section consisted if MCQ related to DSA,OS,DBMS.The aptitude section consisted of questions related to basic mathematics.

Q1. 
Candies Distribution Problem Statement
Prateek is a kindergarten teacher with a mission to distribute candies to students based on their performance. Each student must get at least one candy, and if two s...read more
Ans. 
The task is to distribute candies to students based on their performance while minimizing the total candies distributed.
• Create an array to store the minimum candies required for each student.

• Iterate through the students' ratings array to determine the minimum candies needed based on the given criteria.

• Consider the ratings of adjacent students to decide the number of candies to distribute.

• Calculate the total candies req...read more
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Medium

It was a technical interview testing the basic skills of OS and DBMS of candidates along with few project discussions from your CV.

Q1. Can you write 15 Linux commands along with their functions?
Ans. 
List of 15 Linux commands with their functions
• ls - list directory contents

• pwd - print working directory

• cd - change directory

• mkdir - make a new directory

• rm - remove files or directories

• cp - copy files and directories

• mv - move or rename files and directories

• grep - search for patterns in files

• chmod - change file permissions

• ps - display information about running processes

• top - display and update sorted information about pr...read more
Answered by AI
Add your answer
Q2. What are DDL (Data Definition Language) and DML (Data Manipulation Language)?
Ans. 
DDL is used to define the structure of database objects, while DML is used to manipulate data within those objects.
• DDL includes commands like CREATE, ALTER, DROP to define database objects like tables, indexes, etc.

• DML includes commands like INSERT, UPDATE, DELETE to manipulate data within tables.

• Example of DDL: CREATE TABLE employees (id INT, name VARCHAR(50));

• Example of DML: INSERT INTO employees VALUES (1, 'John Doe
Answered by AI
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

Q1. 
Longest Increasing Subsequence Problem Statement
Given 'N' students standing in a row with specific heights, your task is to find the length of the longest strictly increasing subsequence of their heights...read more
Ans. 
Find the length of the longest strictly increasing subsequence of heights of students in a row.
• Iterate through the heights array and for each element, find the length of the longest increasing subsequence ending at that element.

• Use dynamic programming to keep track of the longest increasing subsequence length for each element.

• Return the maximum length found as the result.
Answered by AI
Add your answer
Q2. 
Overlapping Intervals Problem Statement
You are given the start and end times of 'N' intervals. Write a function to determine if any two intervals overlap.
Note:
If an interval ends at time T and anothe...read more
Ans. 
Given start and end times of intervals, determine if any two intervals overlap.
• Iterate through intervals and check if any two intervals overlap by comparing their start and end times

• Sort intervals based on start times for efficient comparison

• Consider edge cases where intervals end and start at the same time
Answered by AI
Add your answer
Q3. What SQL queries were asked during your interview?
Ans. 
Various SQL queries related to data manipulation and retrieval were asked during the interview.
• Basic SELECT queries to retrieve data from a single table

• JOIN queries to retrieve data from multiple tables based on a common column

• Aggregate functions like COUNT, SUM, AVG, etc. to perform calculations on data

• Subqueries to retrieve data based on the result of another query

• UPDATE queries to modify existing data in a table

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

Round duration - 60 Minutes
Round difficulty - Medium

Q1. 
Zig-Zag String Problem Statement
Given a string STR of size N and an integer M representing the number of rows in the zig-zag pattern, return the string formed by concatenating all rows when the string ST...read more
Ans. 
Arrange a string in zig-zag pattern with given number of rows and concatenate the rows.
• Iterate through the string and distribute characters to rows based on zig-zag pattern

• Concatenate the characters in each row to get the final result

• Handle edge cases like when number of rows is 1 or equal to the length of the string
Answered by AI
Add your answer
Q2. 
Next Permutation Problem Statement
You are given a permutation of 'N' integers. A sequence of 'N' integers is considered a permutation if it includes all integers from 1 to 'N' exactly once. Your task is ...read more
Ans. 
The task is to rearrange a given permutation of 'N' integers to form the lexicographically next greater permutation.
• Iterate from right to left to find the first element that is smaller than the element to its right.

• Swap this element with the smallest element to its right that is greater than it.

• Reverse the elements to the right of the swapped element to get the lexicographically next greater permutation.
Answered by AI
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

Q1. 
Remove Consecutive Duplicates Problem Statement
Given a string S, your task is to recursively remove all consecutive duplicate characters from the string.
Input:
String S
Output:
Output string
Constr...read more
Ans. 
Recursively remove consecutive duplicate characters from a string.
• Use recursion to check if the current character is the same as the next character, if so skip the next character

• Base case: if the string is empty or has only one character, return the string

• Example: Input: 'aaabcc', Output: 'abc'
Answered by AI
Add your answer
Q2. 
Print Permutations - String Problem Statement
Given an input string 'S', you are tasked with finding and returning all possible permutations of the input string.
Input:
The first and only line of input ...read more
Ans. 
Return all possible permutations of a given input string.
• Use recursion to generate all possible permutations of the input string.

• Swap characters at different positions to generate permutations.

• Handle duplicate characters in the input string by using a set to store unique permutations.
Answered by AI
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

Q1. Design an e-commerce website similar to Flipkart or Amazon.
Ans. 
Design an e-commerce website similar to Flipkart or Amazon.
• Implement user-friendly interface for easy navigation

• Include search functionality with filters for products

• Incorporate secure payment gateway for transactions

• Provide personalized recommendations based on user behavior

• Include customer reviews and ratings for products

• Implement order tracking and delivery status updates

• Offer various payment options like credit/deb
Answered by AI
Add your answer