Intellect Design Arena Trainee Interview Questions and Answers

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

Q1. Project worked in ur previus company
Add your answer
Q2. Explain in detail what tools used, how you deployed etc
Add your answer

Q1. OOPS concepts to be explained
Add your answer

Q1. They discuss about more of the basics to advance technical queries on the product they recruiting you
Add your answer
Q2. How s the Azure pricing
Ans. 
Azure pricing is based on usage and offers various pricing options.
• Azure pricing is pay-as-you-go, meaning you only pay for what you use

• There are different pricing tiers based on services and resources

• Discounts are available for long-term commitments or reserved instances
Answered by AI
Add your answer

Q1. 1 hour- basic question about DB, SQL, Cloud.
Add your answer

Q1. Case study on Data migration process and tools. 4- 5 question on solution
Add your answer

Q1. Trchnical question basics and advance both.
Add your answer

Q1. Scenario based questions on situation. Mostly problem solving skill.
Add your answer

Q1. Tell me about yourself
Add your answer

Q1. Tell me about yourself
Add your answer

Q1. Azure PAAS / IAAS Azure Devops CI/CD Azure Landing Zone AKS Non MS product Architecture & design
Add your answer

Q1. Same as above in depth
Add your answer

Same as above in different scenario

Q1. Hiring Manger Round
Add your answer