👩💻 Technical Assesment:
JAVA, C# and Python (SET 1)
2 SQL - (Basic SELECT, WHERE and AGREGATE Function and JOINS With GROUP BY and
HAVING)
1 Question : Display user who have more than 5 Follower Count (Schema and Table
where given)
2 Coding:
1 - Water Stream (Replace 0 with next Non Zero Value)
Example: 5,[2,0,-3,0,5]
Output: [2,-3,-3,5,5]
2 - Maximum first and last Character
Example: a ab abb cd bd abc
Output a, b -> (First Characters count a: 4, b:1, c:1)
(Last Characters count a: 1, b:2, c:1, d:1)
10 MCQ based on Clusters Programming Language
1. JAVA,Python, C# - Exception Handling, Error, Code output snippet, Memory related
Question
10 Cloud MCQ (For Cluster 2)
Basics and Fully based on understanding.
HTML, CSS and JS (Cluster 1 and Cluster 3)
Question:
Snippets where Provided Just need to match the Question and fix errors
Button click functionality (Hexa value -> Background colour)
🔹 Cluster 1 & Cluster 3 – Java / C#
Java
1. Self Introduction
2. OOPs concepts in detail
3. SQL JOINS – types and working
4. Foreign key & Primary key
5. Query on joins
6. Coding in method overloading
7. Array declaration
8. DML queries – delete table, delete row
9. Willingness to relocate
10.Willingness to work night shifts
11.Why you chose Java
12.Reverse a String in Java
13.Why use StringBuilder
14.Difference between String and StringBuilder
15.Inheritance implementation
16.Access modifiers
17.Ways to access private variables in a class
18.Java 8 Streams
19.ML libraries used in project
20.Aptitude questions (Percentage)
21.Project discussion
22.Any questions to ask
🔹 Cluster 2 – C#
1. College experience and learning
2. OOPs concepts in detail (with syntax)
3. SQL – stored procedures, ACID properties, LEFT JOIN, INNER JOIN
4. Foreign key & Primary key
5. Query on joins (basic)
6. Coding – reverse a string (Java/C# allowed)
🔹 Cluster 2 – Python
1. Self Introduction
2. Project explanation (one in detail)
3. Why Python?
4. OOPs in Python – class, objects, inheritance
5. Difference between Tuple and List
6. Difference between Primary Key and Unique Key
7. Can Foreign Key be NULL?
8. SQL basics (DDL, DML, DQL, TCL, DCL)
9. SQL joins and practical join queries (with WHERE and GROUP BY)
10.GROUP BY explanation
11.Libraries in Python (NumPy, Pandas, etc.) and their uses
12.AI/ML/DL/NLP concepts
● Tokenization
● Types of ML
● Deep Learning basics
● GenAI tools used (e.g., Hugging Face models)
13.Favorite AI tool and why
14.NLP concepts explained
15.Encryption and abstraction concepts
16.AWS services (any 5)
17.Issues faced (personal/technical) & how you overcame them
18.Willingness to relocate, night shift, or work in other domains
Coding Questions (Python)
● Print duplicate elements in an array
● Print duplicate characters in a string with count
● Reverse a string (with/without spaces)
● Count frequency of characters in a string
● Count string length without spaces
● Fibonacci series
● Read from a file in Python
● Remove duplicates from a list
● Check if a number is prime
● Frequency count in string
🔹 Analytical & Logical Questions
1. You have a 3-liter jar and a 5-liter jar. How will you measure 2 liters?
2. You have 3-liter, 5-liter, and 8-liter jars. How will you measure 4 liters?
3. A container has 10 blue, 5 red, 7 green balls. The room is dark:
○ Minimum number of balls to pick to get at least one blue ball.
○ Minimum number of balls to pick to get at least one of each color.
