CTS Interview - TR + HR

TR + HR – 1 Round Only

Update Resume – Upload in Superset

Cognizant Interview – Important Instructions

1. Join Interview 20 min before.

2. Rescheduling is too much delay – Be available through the day irrespective of your slots.

3. Use Laptop with webcam & mic; ensure very Good Internet.

4. Dress formally for the interview it's very important.

5. Sit in a quiet place with good lighting and clear and clean background.

6. Camera & mic will be ON throughout – avoid any malpractice.

7. Keep college ID, Aadhar Card and soft copy of Resume & all Marks sheets.

8. 360° View – No third person in room.

9. Coding – Compiler – Execute Code – Based on Cluster in Test.

Before your next Online Interview:

0. Keep a pen & paper ready

1. Keep a water bottle with you

2. Put your phone on silent

3. Keep your laptop on charging

4. Use an external mic/earphone

5. Close ALL unnecessary browser tabs, keep ONLY interview-related ones open

6. Keep your phone's hotspot on, you never know

7. Tell everyone at your home that you've a meeting

8. Login 15 minutes before (very important)

9. Speak out loud few Tongue-Twisters, it's a great speaking exercise for clear speech

10. Keep the video ON, it's highly underrated. It adds an extra level to your communication (very
important)

11. Get a smile on the face, a BIG one, brain releases endorphins which helps you set the
mood
12. Close your eyes, take a very very very deep breath

13. As soon as you open your eyes, 100% undivided attention on the call, 100% undivided focus

14. As soon as the interviewer joins, make the FIRST MOVE, greet him, "Hi Sir, Good Morning /
Good Evening !", with a BIG smile on your face.

Interview Slot Mail

Sign in to Superset Account: app.joinsuperset.com

Interview Completed Confirmation:
No Show Status - Rejected

[email protected]
 90+ Interview Experience

I1. Cluster: Python

1. Self intro

2. Show id card

3. Project related

4. Skills that we know

5. Data types in python

6. List, tuple, array di erences

7. How to add 2 dictionaries

8. Insert, update, delete operations fast in which

9. Reverse of string code

10. Factorial code

Any queries??

I2. Cluster: python

1.self introduction

2 id verification

3.factorial of a number

4.sum of two numbers

5.logical questions

6.scenairo based questions

7.di erence between list, tuple, set

8.will you relocate to Chennai or coimbatore

9.able to work at any shifts

10.lambda function

11.will you join in between 10 may to 25th may

12. Any questions

I3:

Cluster:Python

1.id verification

2.Show your room 360 degree

3.Self Introduction

4.About final year project

5.Which language are u comfortable with?

6.Explain list,tuple,dictionary,set and syntax?

7.Create one list with duplicates and asked how can u remove the duplicates from list?

8.Write a dictionary using keys like name,age and employee_id and asked to use same name key
with di erent name in the same dictionary?And asked the output to guess without executing

9.What is list comprehension and asked to write a program to print even numbers from 1 to 10?

10.How can you write the multi-line strings?

11.Write a program to swap the values without using temporary variable?

12.What is lambda function?

13.What are the Excepthion handlers in Python?

14.What are the packages you used in python?

15.What is Pandas?

16.What is di erence between module and package?

17.What are magic keywords in python?

SQL:

18.What is UNION and UNION ALL?

19.What are the types of JOINS and explain?

20.Write a query of employees table and print the second highest salary in the table?

21.What are ACID properties?

22.How the DROP and TRUNCATE will work?

23.What are the cloud computing models?

24.Are u willing to relocate to Chennai or Coimbatore?

25.Are u ok with any shift?

26.Are u ready to join in between may10 to may 25th for internship?

27.Are u ok with doing projects on new technologies?

28.When the error will show in python ,how will you solve the error?

I4:

Cluster: Python

1. Self introduction

2. ⁠Id verification

3. ⁠what is cloud computing

4. ⁠what is aws

5. ⁠why python and features of python

6. ⁠about project

7. ⁠Types of data types

8. ⁠di erence between int and float

9. ⁠program to print factorial of a number

10. Factorial of number using recursion

11. ⁠what is data base

12. ⁠di erence between data base and database management system

13. ⁠what is sql

14. ⁠explain oops

15. ⁠di erence between abstraction and encapsulation

16.types of cloud computing

17.what challenges you faced while doing project

18.what is Amazon EC2

19.Are you willing relocate to south indian and north India

20.will you able to work at any shifts

21.Any questions
I5: Cluster : Python

Role: Genc

1. Show I'd card

2. Self intro

3. Explain about internships and projects that u have done

4. Which code was very tough for you

5. Character frequency code, string is hard-coded

6. Merge-sort code

7. What is cloud

8. Services for cloud

9. Examples for cloud technology

10. Ai ml algorithms

11. CNN, RNN di erences

12. What is LSTM

13. Y can't I use CNN instead of LSTM

14. In depth concepts of rnn CNN

15. Activation function

16. Vanishing gradient problem

17. sql empname and salary how to find thrid highest and second highest salary

18. Iaas, paas, saas

19. What is the issue with LSTM

20. Text to screen LSTM support usecase

21. Give me di erent types of techniques classification in ai&ml

22. Are you willing to relocate to Chennai and coimbatore?

23. Are u willing to work at any shifts?

24. A new batch starts in between may 10 to 25 are you okay to join in that batch?

25. Are you willing to work on any domain?

25. Any questions

I6: Role : Gen C

Cluster : python

Show your id card

1.Self introduction

2.Project Related Questions

3.About memory management in python

4.Di erence between == and is

5.Virtual environment

6.Define and Di erentiate package & modules, about packages

7.Decorator & Generator

8.Collection Datatypes

9.Di erence between break, continue & pass

10.Shallow copy & deep copy

11.overlading and overriding

12.Exception handling and finally block

Program-Remove duplicate elements and print without using built-in functions

Cloud computing Basics

asked to show the 360° view of the room

SQL

1.DML,DDL commands

2.Drop & truncate

3.primary key & unique key

4.left outer join & right outer join di erence

-work from home and work from o ice- which is better?

-Are you willing to relocate and rotational shifts?

-Any Questions?
I7:

Cluster: python

Role: GenC

1. Show me your ID card

2. Self intro

3. Tell me about your recent project

4. Libraries used in the project

5. Explain about list and tuple by using a simple program

6. Can you modify a tuple taken in the example program

7. Can you add a string to a tuple give example

8. Rate yourself in OOPS concept

9. Explain inheritance with example

10. Di erence between inheritance and polymorphism

11. Example for method overloading

12. Rate yourself in MYSQL

13. Datatypes in MYSQL

14. Explain foreign key and primary key

15. How can you import and export data in my MYSQL

16. Given a query to explain

17. Explain INTO OUTFILE command mean

18. Di erence between inner and cross join

19. Explain stored procedures

20. What are 2 types of sub queries

21. Scenario based Questions

22. Will to relocate and night shifts

I8:

Cluster : python

1.self introduction

2.id verification

3.factorial of a number
4.sum of two numbers

5.logical questions

6.sceniro based questions

7.di erence between list, tuple, set

8.will you relocate to Chennai or coimbatore

9.able to work at any shifts

10.lambda function

11.will you join in between 10 may to 25th may

12. Any questions

I9:

Cluster : Python

Role : GenC

1. Self introduction

2. Show room 360 view

3. ⁠about project

4. ⁠program to print reverse string

5. ⁠program to perform list operations

6. ⁠program on sorting

7. ⁠program on inbuilt methods

8. ⁠program to perform dict operations

9. ⁠program to swap numbers without using temp variable

10. ⁠Oops concepts

11. ⁠types of data-types

12. ⁠what is lambda function

13. ⁠Program to print numbers using Lambda function

14. ⁠Features of python

15. ⁠Which type of python programming language it is

16. ⁠How memory is managed in python

17. ⁠Sql code to print duplicates names in it

18. ⁠Sql code to select the rows from given table

19. ⁠Di erence between drop, truncate, delete

20. ⁠joins

21. ⁠types of cloud computing

22. ⁠cloud services

23. ⁠what is use of load balancing

24. Hobbies

25. ⁠will you relocate to chennai or coimbatore

26. ⁠will you able to work any shifts

27. ⁠will you join in between 10 May to 25 May

28. ⁠family background

29. ⁠Any questions

I10:

Cluster : Python

Role: Genc

1.Self introduction

2.How to remove duplicates from a data base

3.what is mutable and immutable

4.Libraries in python

5.Program to print reverse of string

6.Sql query to print distinct of elements in a table

7.what are the data types in python

8.variables in python

9.inner join

10.shallow copy and deep copy

11.Truncate and drop

12.Delete and truncate di erence.

13.What is usage of tuple

14.Cloud Technologies-paas,faas,saas
15.Di erence between ec2 and s3

16.360 view of room

17.Are you comfortable to relocate to Chennai or coimbatore with any shifts

18.Are you willing to join between May 10 to may 25

19.Any questions

I11:

Role : Genc

cluster: Java

1.show me your I'd

2.show me your room

3.self introduction

4.write a code in Fibonacci

5.writw a code in prime numbers

6.second highest salary

7.tell me about Polymorphism

8.are you willing to relocate

9.tell me about India Pakistan war for 1 min

10.are you kk for rotational shifts

I12:

Cluster: Python

1. Show me your ID

2. Show me your surroundings

3. Are you willing to relocate to Chennai, Coimbatore?

4. Oops concepts

5. Write a Code to find the nearest number in some pack of random numbers.

6. SQL full Form and basics.

7. Types of joins in SQL.

I13:

Role: Genc

Cluster : Python

1. self introduction

2. Pre ered language

3. Asked to show ID card

4. Subjects in your btech course.

5. What is ur primary domain in your course?

6. Asked machine learning algorithms

7.coding question:

I want to know what is the character frequency of each character in the string.A repetition of
characters count.

8. SQL Query: Write a query to find highest salary and third highest salary in employee table.

9. Do you know any cloud computing fundamentals? Do you know what is cloud computing?
What are the types of clouds that we have?

10. AWS related Questions

11. Alpha beta pruning

12. Explain your project

13. What algorithms do you know in machine learning explain them with example

14. Di erence between clustering and classification and also explain KNN.

15. Explain back propagation with example

16. One-hot encoding in Machine learning

17. Some cloud fundamentals

18. Explain Saas,Paas,Iaas

HR questions:

-willing to relocate to chennai or coimbatore

-Are you ok with any shift

-are you willing to join on-going batch now?

-Any questions
I14:

Role : GenC

Cluster : python

1.Self intro

2.About project

3.Primary key? Di erent between primary key and unique key?

4.Write a program by using tuple and list with same elements then add an element to them and
remove 3rd element?

5.About joins?

6.Di erence between flask and Django?

7.Any questions?

I15:

Role:Genc

Cluster: python

1.show id card

2.self intro

3.asked questions about project

4.python datatypes

5.di between list tuple dictionary set

6.syntax for list and dictionary

7.write a code to remove duplicate elements from the list & print the list

8.create a variable as target find the combination from the list

9.di inner and left join

10.write a sql query to find second highest salary in employee table

11.di between truncate and drop

12.what is unique and unique all ,why with is used in sql and what is cte

13.why limit is used in sql

14.about cloud computing

15.what is saas ,paas,iaas

16.are you willing to relocate to Chennai or Coimbatore

17.Are you comfortable with any shifts

18.Any one asked to pay in this hiring process

19.if you are shortlisted are you ready to join intership in next 2 weeks.

I16:

Role: Genc

Cluster: python

1. Willng to relocate

2. Willing to do night shifts

3. Willing to learn new technologies

4. Tell us about yourself

5. Tell me what do you know about python

6. Program on reverse of string

7. Sql queries

8. Do you know about storage procedures

9. Normalisation

10. Show me your id card

11. Show me your room

12. Any queries

13. Primary key and foreign key

14. Opps concepts

15. Polymorphism and encapsulation

I17:

Cluster: python

Show your id card

1.Self intro

2.Show your room 360 view

3.About project

4.Algorithms used in project

5.about control loops

6.explain tuple in python

7.explain types of databases

8.python program to calculate simple interest

9.program to calculate age by giving birth date as inputs

10.how many times can we subtract 10 from 100

11.Any questions

I18:

Cluster : Java

1.Self introduction

2.project and related questions

3.html table creation

4.css

5.jdk 8 features and current using version

6.interface

7.functional interface

8.producer and consumer problem

9.multi threading

10.syncrhonization

11.collection frame work

12.vector

13.di erence between array list and linked list

14 di between arraylist and vector

15.factorial program

16.sql queries

17.define order by

18.di erence between inner join and left join

19.how to connect frontend with python(project related)

20.Are u willing to relocate

I19:

Good afternoon sir,

I've just completed my interview...

Cluster: Java

Questions:

- Self Intro

- Tell about your Project

- Why is multiple inheritance not allowed in java

- how can we achieve multiple inheritance

- What is polymorphism

- Do you the formula of Simple Interest

- 2 problems related to Simple Interest

- What is primary key

- what is foreign key

- Can primary key be null?

- Willing to relocate to Chennai?

- Asked about timings and date I can join in for!

Programs:

- Number Palindrome

- Fibonacci series

SQL queries

- Second highest marks in student table

- Print employee name if it contains REDDY

I20:

Cluster: python

Show your id card

1. Self intro

2. Show your room 360 view

3. About project

4. Algorithms used in project

5. Joins in sql

6. Data types in python

7. Array

8. Any questions

I21:

Cluster : Python

Self intro

Asked to show id card

About project's (Major&minor)

How can python be learned?

What are the uses of python?

Di erence between python and java?

What are function? And it's types

What are literals in python?

What is the dictionary in python?

Uses of anonymous and lamba function?

When is python developed?

How non technical people can learn python?

What is cloud computing ?

What Is AWS? Services provided in AWS?

What is Saas, iaas,paas?

Why cognizant?

What should be the qualities of manager?

Are you willing to relocate to Chennai or kochi?

Are you comfortable with any shifts?

Program’s: -

Print your name and date of birth

Addition of two numbers

I23:

Role :Genc

Slot : Python

1. Introduction

2. Project related questions

3. Memory management in python

4. Python data structures

5. Applications of data types

6. questions on list and arrays

7. Questions on tuple

8. What is dictionary

9. Deep copy and shollow copy

10. GIL in python

11. What are I/O tasks ?

SQL

1. Primary key and unique key

2. How many null values can be there in unique key ?

3. Explain joins

4. How did you connect database in your project ?

5. Explain dense_rank,row_number,rank in sql ?

Question on number series

Hr questions

Programs :

1.Reverse a string without built in functions

2.Create two dictionaries and merge them

Sql

1. Query related to joins

2.5th highest salary

I24:

Cluster:python
Show your id card

Self intro

About project

More questions about project

Write code for insertion sort

Data types in python

Acid properties

Sql joins

Are u willing relocate?

Any queries

I25:

Cluster : Python

1.Self introduction

2.Program to print greatest among two numbers

3.Di erence between set and dictionary

4.Libraries in python

5.Sql joins

6.Aptitude questions

7.Cloud Technologies

8.Oops concepts

9.Are you comfortable with any shifts

10.Any questions

I26:

Cluster: Python

Show your ID card

Self Intro

About Project

Depth questions on projects

Program for finding maximum element

Program for duplicate elements

Logical questions

Left join

What is TCL

What is Oops

What is polymorphism and di erent types in polymorphism

What is exception handling

Any questions

I27:

Cluster python:

Show your id card

Self intro

Di erence between == and is

About memory management in python

What is a generator, decorator

Significance of generator

Data structures in python

Di erence between tuple, list

What set

Di erence between and package and modules

Do you know any packages in python

What is cloud computing

What virtual environment

Any idea on aws cloud

Technologies used project

Max element in list

Show 360°

What is primary key, foreign key

What is unique constraint

Can we declare multiple foreign keys, primary keys in same table

Are you willing to relocate

Will you join by may 15th

Are you comfortable with any shifts

On what technologies you want to work

I28:

Cluster: C#

1.self introduction

2.id verification

3.keys in sql

4. program on reversed string

5. joins in sql

6. const value

7. what is interface

8. four pillars in oops concept

9. sequel in database (SQL also called as sequel)

10. some questions based on project

11.are you willing to relocate to Chennai or Coimbatore

I29:

𝙲𝚕𝚞𝚜𝚝𝚎𝚛:𝚌#

1.𝚒𝚗𝚝𝚛𝚘𝚍𝚞𝚌𝚝𝚒𝚘𝚗

2.𝚒𝚍 𝚟𝚎𝚛𝚒𝚏𝚒𝚌𝚊𝚝𝚒𝚘𝚗

3.𝚜𝚘𝚖𝚎 𝚚𝚞𝚎𝚜𝚝𝚒𝚘𝚗 𝚊𝚋𝚘𝚞𝚝 𝚙𝚛𝚘𝚓𝚎𝚌𝚝

4.𝚙𝚛𝚒𝚖𝚊𝚛𝚢 𝚔𝚎𝚢

5.𝙲𝙻𝚁

6.𝚠𝚑𝚊𝚝 𝚍𝚘 𝚢𝚘𝚞 𝚔𝚗𝚘𝚠 𝚊𝚋𝚘𝚞𝚝 𝚌#

7.𝚋𝚎𝚑𝚊𝚟𝚒𝚘𝚞𝚛𝚊𝚕 𝚚𝚞𝚎𝚜𝚝𝚒𝚘𝚗𝚜

8.𝚊𝚛𝚎 𝚢𝚘𝚞 𝚠𝚒𝚕𝚕𝚒𝚗𝚐 𝚝𝚘 𝚓𝚘𝚒𝚗 𝚒𝚗 2-3 𝚠𝚎𝚎𝚔𝚜

9.𝚊𝚛𝚎 𝚢𝚘𝚞 𝚠𝚒𝚕𝚕𝚒𝚗𝚐 𝚝𝚘 𝚛𝚎𝚕𝚘𝚌𝚊𝚝𝚎

10.𝚠𝚑𝚊𝚝 𝚍𝚘 𝚢𝚘𝚞 𝚔𝚗𝚘𝚠 𝚊𝚋𝚘𝚞𝚝 𝚌𝚘𝚐𝚗𝚒𝚣𝚊𝚗𝚝

I30:
𝙲𝚕𝚞𝚜𝚝𝚎𝚛:𝚌#

1.𝚒𝚗𝚝𝚛𝚘𝚍𝚞𝚌𝚝𝚒𝚘𝚗

2.𝚒𝚍 𝚟𝚎𝚛𝚒𝚏𝚒𝚌𝚊𝚝𝚒𝚘𝚗

3.𝚜𝚘𝚖𝚎 𝚚𝚞𝚎𝚜𝚝𝚒𝚘𝚗 𝚊𝚋𝚘𝚞𝚝 𝚙𝚛𝚘𝚓𝚎𝚌𝚝

4.𝚙𝚛𝚒𝚖𝚊𝚛𝚢 𝚔𝚎𝚢

5.𝙲𝙻𝚁

6.𝚠𝚑𝚊𝚝 𝚍𝚘 𝚢𝚘𝚞 𝚔𝚗𝚘𝚠 𝚊𝚋𝚘𝚞𝚝 𝚌#

7.𝚋𝚎𝚑𝚊𝚟𝚒𝚘𝚞𝚛𝚊𝚕 𝚚𝚞𝚎𝚜𝚝𝚒𝚘𝚗𝚜

8.𝚊𝚛𝚎 𝚢𝚘𝚞 𝚠𝚒𝚕𝚕𝚒𝚗𝚐 𝚝𝚘 𝚓𝚘𝚒𝚗 𝚒𝚗 2-3 𝚠𝚎𝚎𝚔𝚜

9.𝚊𝚛𝚎 𝚢𝚘𝚞 𝚠𝚒𝚕𝚕𝚒𝚗𝚐 𝚝𝚘 𝚛𝚎𝚕𝚘𝚌𝚊𝚝𝚎

10.𝚠𝚑𝚊𝚝 𝚍𝚘 𝚢𝚘𝚞 𝚔𝚗𝚘𝚠 𝚊𝚋𝚘𝚞𝚝 𝚌𝚘𝚐𝚗𝚒𝚣𝚊𝚗𝚝

I31:
Cluster: python

1.show me I'd card

2 . When did you applied for cognizant

3.which language you familiar with

4. Do you know mangoes

5. Show me your room 360 degree

6. Code to print your name no.of letters count

7. Sql query to find maximum third salary of employee

8. About project

9. About cursors

10. About pythonbasics

11. When you will join

12. Are you ok to relocate

13. How do server works internally

14. How you applied for cognizant

15. Any questions

I32:

Cluster : Python

1. Self introduction

2. About project

3. Which technology used in project

4. Any libraries used

5. For testing, which software did you use

6. What is postman

7. Status codes 404 and 500

8. Any qstns

I33:

Cluster:Python

1.Show your clg id card.

2.Tell me your CGPA of B.Tech.

2.1234554321 write a program to print this output.

3.Delete a record query which has name=john.

4.List,Tuple di erence.

5.Data types in python.

6.Asked me about are you currently in any training.

7.Do you have any questions to ask.

8.Are you willing to relocate to coimbatore,chennai.

9.Are you comfortable in learning new technologies like dotnet,cloud.

10.Is this drive on campus or o campus.

11.How many of your friends completed the cognizant interview.

12.Are you ok to join on May 15.

I34:

cluster : python

360 view of room

id
self intro

write 2 sql commands on the senario

write a program to print voting eligiblity if age > 18

write example for taking function as argument

program to swap elements

/ and //

shallow and deep copy

questions based on senarios

any questions?

I35:

Cluster : Python

1) Self Introduction

2) Project , related questions

3) Datatypes

4) Program for list,tuple, dictionary

5) program for reverse of the list

6) program for middle number of the list

7) Di erence between Array & List

8) what is docstring

9) program for maximum substring of a string

10) program for prime numbers

11) What is data slicing

12) Syntax for data slicing

13) tools in data slicing

I36:

Interviewer asked directly coding questions to create ur name and give letters number of
repeated and max number.

How to connect to a database to python.

Show 360° room

Data base questions :-

What is database

How to create Frontend

How we create tables

What is python?

Any questions?

I37:

Cluster :python

Self intro

Write any program

Sql statements

About project

Datatypes

Factorial number

Tracing the program

Sorting algorithm

Hr questions

I38:

Cluster: Python

Tell me about yourself

About the projects

Sql joins

Logical questions

Primary key and unique

Willing to relocate

Willing to adapt any technologies

Sql:

Maximum marks

Python:
Pattern

Duplicate element from list

Maximum element from the list

I39:

Cluster : python

1. show id card

2. self intro

3. which language u r good at?

4. data structures in python ?

5. data types?

6. di . b/w list and tuple

7. do u know function in python.

8. write a code by using function.

9. what do u know in sql

10. tell sql commands

11. do u know primary key? Define it.

12. asks about college?

13. any questions

I40:

Show your id card

Self intro

Willing to relocate to coimbatore or chennai

Are you ok to night shifts

Are you ok for extra work time

SQL :

What is DBMS

Di erence between database and schema

Objects used in schema

Explain all joins with queries

Explain DML and DDL statements

Di erence between truncate and drop

Given a scenario and asked which situation is truncate and drop

Explain where, group by , order by, Having clause

Write a sql query using all these

Set operators in sql

Operators in sql

Python :

Features

Datatypes

Set tuple di erence

Mutable immutable di erence

Explain slicing and indexing

Explain Dictionary

Cloud computing concepts

Any questions??

Programs:

Implement slicing using python

Write reverse of a number using python

Write Fibonacci series

And implement Fibonacci series using recursion

I41:

Cluster : python

1.self intro

2.projects(algorithms,libraries)

3.hr questions

4.sql gave a scenario told to write query.

5.list,tuple,set,dictionaries
6.aptitude question

7.class,object,instance variable,class variable, constructor

8 what is interpreter,idle

9.gave a scenerio told to write code regarding oops concepts.

10.what is anonymous function?

11.Any questions

I42:

cluster: JAVA

1) skills

2)java features

3)public, static uses

4)can we use first static and then public

5)void vs main di erences

6)can main method overloaded

7)object is instance or not

8)what is object and how is it related to the class

8)do you know associate operators

9)di erences between string and string bu er

10)garbage collection and types of garbage collection

11)In SQL, tell me about joins

12)How to use descending keyword

13)what is the di erence between group by and order by

14)stored procedure in SQL

15)tags(img, video, audio, ancher)

16)are you willing to relocate for Chennai or Coimbatore

17)are you ready with any shifts

18)Any queries?

programming questions: write a program using objects and explanation

I43:

Cluster: Java

Duration: 25 Minutes

1.Introduction

2.About project mentioned in resume

3.Palindrome program in java

4.Di erence between List and Set in Python

5. SQL JOINS

6.Syntax of select statement

7.DML and DDL in SQL

8.Normalisation and De-Normalisation

9.Can we use 2 primary keys in a single table ?

10.Primary key, Unique Key, Foreign Key.

11.Triggers, Views, Aggregate functions

12.ACID Properties in SQL

13.Group by and Having in SQL

14.About hobbies mentioned in resume

15.Any Questions.

I44:

Cluster: Java

1.Introduce yourself.

2.Show me id card.

3.Show your Room 360 view.

4.How many projects you did.

5.Explain about Project.

6.Questions on Project.

7.Explain Oops concepts. Without definitions.

8.What are conditional statements in Java.

9.When we use return type. When we avoid return type.

10.What are Exceptional Handlings in Java.

11.Write a Java program to add two strings without using " + " or any inbuilt function.

12.Write a Java Program to print Reverse of a String.

13.Add Exceptional Handlings to Reverse of string program.

14.Write a Java program with condinational statements.

15.Write a SQL query with three columns (emp_id, emp_name, Domain).

i.Delete only third row.

ii.Delete Entire Table.

16.Are you ready to relocate.

17.Are you okay with any shifts.

18.Any Queries.

I45:

Role: GenC

Cluster: Initially my cluster was java, but I requested to change to python and ML

Total duration :45 min

ML-Focused (First 30 mins – Deep & Real-Time Based)

Identity Verification

1. Self-introduction

2. About the projects in my resume

*Algorithms used

*Why those algo's, not others

*Working of algorithms

3. Internship experience and tools used

4. Machine learning algorithms – brief explanation

5. GenAI concepts (since I mentioned in resume)

6. Explanation of one end-to-end ML project

7. Role of a Data Scientist in real-world use cases

8. Visualization frameworks used in ML

Python & SQL-Based (Last 15 mins – Real-Time & Practical)

1. Python features

2. OOPs concepts – real-time examples for each principle

3. Lambda function – real-life use case

4. How to define and print a function in Python

5. Python program to swap two numbers using arithmetic operations

6. SQL joins – real-time examples with outputs from given tables

7. Final question – “Do you have any questions?”

I46:

Cluster: Java

1.Show your room 360 view.

2.Show your id card.

3.self intro.

4.what is your cluster.Tell me Your Superset ID.

5 how much you would rate yourself in programming out of 5

6.write a program to print sequence of even numbers upto n.

7.write a Program to print a number which is divisible by both 3 and 5.

8.Write any program of your choice.

9.what is OOP'S.

10.what is encapsulation .

11.what is multiple inheritance.

12.what is di erence between Encapsulation and Abstraction.

13.what is a class and Object.

14.What is Self Join.and Types of Joins.

15.Are you willing to relocate.

16.Are you Flexible to work on any shifts.

17.When will you available to join the company.

18.Any Questions.

I47:

Role :Genc

Cluster ; java

Language asked - java and cloud ...

1. College Id card
2. Any Government Id proof .

3. Self introduction

4. CGPA OF B TECH

5. WHY EE CORE TO IT SECTOR .

6. purpose of changing ..to IT SECTOR

7. Ideology of Implementation of core in IT SECTOR.

8. Cloud foundations questions.

9. Have u done Cloud computing certification .

10. RDMS full from

11.Favorite Subject in Core .

12. What is meant by EE - CORONA EFFECT

13. Single and three phase Di erence and live examples ..

14. About SQL rating.. out 5 .

15. What is meant by Threshold value of electronics.

16. Swap the numbers program ..only logic ...with and without additional variable.

17. Cloud structure...why we use and how it can useful for us....tari of cloud usage...how it will
be charged.

18. I asked Feedback... Sir said to need to know about RDMS ..

TOTAL DURATION - 25 MINUTES.

I48:

Cluster : Java

Role : Gen C

Language Asked: Java Script, Python

Data base : SQL

Asked for 360° Room View before starting

1.Self Introduction

2.What Projects u did?

3.Explain any one of the project?

4.Write a Program in JavaScript for List and accessing elements in List?

5.Write a program for the reverse of the string?

6.Reverse of a string Program by taking user inputs?

7.Do you Know Exception?

8.Write an Exception program showing the concept?

9.write a Python code to add two dictionaries and update them?

10.Write an SQL query to print repeated Names in an organization showing Count?

11.Write an SQL Query?

to print highest salary in an Organization?

12.write an SQL Query to print 2nd highest salary in an Organization?

I49:

cluster : Java

programs:

reverse of a number

declare and initialise a string

Queries:

using joins

using functions

Using clauses

Theory:

joins in sql

filters in sql

functions in sql

Usage of functions in sq

oops in java

Project

I50:

Cluster: java

1.Show your room 360 view

2.Show your id card

3.self intro
4.Take user input of name ,city,age, salary without scanner class (coding)

5.primary key unique key di erences

6.Group by clause

7.Having clause

8.version of jdk your using

9.How did u installed jdk in your system.

I51:

05/05/2025

Cluster : Java

Role : Genc

Show your room in 360 view

1: Show ur college id

2: oops concepts

3: Abstraction

4: Exception handling

5: Html Css related questions

6: Reverse string problem in Java

7: polymorphism

8: can you design login page for my name in html

9: abstraction example

10: about project

I52:

28/06/2025 - cluster 1

Show me your Id card

Tell me about yourself

Explain Arrays

Gave 3 questions on arrays told me to choose one

1. Given an integer array print the duplicate number in the array of number

2. Vowels
Gave SQL querie and told me to find the mistake in the query

Delete Truncate Drop

Index in SQL

View in SQL

Any questions

I53:

Genc next interview

Duration:40 mins

Two panel members

1.self introduction

2.Project in detail about 3.machine learning algorithms used in project

4.situational questions about bulb, waterjug, missionary problem.

5.Polymorphism

6.encapsulation

7.Some HTML tags

8.Relocation in Bangalore

9.Can you join in 15 days?

10.Sql queries

11.Joins

12. Write a sql query retrieve duplicates in the column.

13. ⁠ write a Java program to get duplicate in the array

14. ⁠ write a Java program armstrong Number

15.why java why not python

16. ⁠why java is considered more?

17. ⁠ are you willing to learn new technologies?

I54:

Cluster: JAVA

Role: GenC Next

Interview Questions:
Panelist 1:

1. Introduce yourself

2. About projects

3. Which stream are you from.

4. What are the programming languages you have learnt.

5. What is object oriented programming.

6. Explain Oops concepts

7. Given a java code and asked to predict the output.

8. Write a program of your choice in Java.

9. Linear data structures and non linear data structures.

Panelist 2:

1. Introduce yourself.

2. Can you explain about your projects and technologies used to implement.

3. Which format have you used to store the location coordinates json or some other. (Related to
the project)

4. Have you used any database in your project.

5. What type of database have you used.

6. Which language have you used to implement your project.

7. Which cloud have you used.

8. How did you track and store the values in the data base (project related)

9. Have you created any tables using SQL.

10. What are arrays.

11. What is linked list and types of linked list.

12. Di erence between array and arrayList.

13. Di erence between linked list and array list.

14. What is super keyword used for.

15. What is this keyword used for.

16. What is inheritance

17. If you need to access the properties or variables and methods of another class what are all
the possible ways. (Any other approaches other than inheritance)

18. What are all the technologies you have covered in your projects.
19. Where will we use parameterized constructors and normal constructors.

20. Which version of java have you used for your project.

21. What are strings in Java and how have you implemented them.

22. Any questions

Program: 1. Fibonacci series ( program of my choice in java, panelist 1)

Program Details: I have been asked to write a program of my choice so I wrote the Fibonacci series
program.

2. Write a program to print unique elements in a string. (Since the util package was not working, I
have been asked to explain the approach of implementation of the program. After that I have been
asked to write a program by taking static input, panelist 2)

Program Details: Take a string as input and remove duplicates from the string and print unique
elements.

Input (given by the panelist) : "siooupun"

Output: sipn

I55:

Cluster : Python

1. Self Introduction

2. Sum of 2 numbers using lambda function

3. Asked Scenario based questions (4)

4. Team work pros and cons

5. OOPS concept

6. Willing recolate anywhere in India

7. Willing to join may 1st week

8. Willing to learn new technologies

9. Flexibility to work in any shift

10. Any questions

I56:

Cluster: Java
1. Self-Introduction

2. Discussion about Final Year Project

3. Program to Print Fibonacci Series

4. Why Strings are Immutable in Java

5. Explanation of OOP Concepts

6. Di erence Between DROP, TRUNCATE, and DELETE; Di erences Between Types of JOINS

7. Diamond Problem in Java

8. Di erence Between StringBuilder and StringBu er

9. Basic HTML Tags

10. Willingness to Work in Any Domain

11. Flexibility to Work in Any Shift

12. Any Questions for the Interviewer

I57:

Cluster: python

1. Asked to show ID card

2. Self intro

3. SQL table creation query

4. Find 2nd highest salary in sql

5. Joins,left join, right join, cross join

6. Query Optimization

7. Di erence between truncate and drop

8. Di erence between list and tuple

9. Di erence between instance variable and class variable

10. Reverse a string program

11. Exception handling

12. Asked to use exception handling on reverse a string program

13. Anonymous function

14. Multiple line string

15. Are you ok to join immediately

16. Are you willing to relocate

17. Show me your room

I58:

1. Self Introduction

2. Which language are you comfortable.

3. How do you rate yourself

4. Di erence between / and // in python

5. Di erence between list and arrays

6. Di erence between set and dictionary

7. What is docstring and explain

8. what is ur cluster ?

9. Why python and why not Java?

10. Fibonacci series code

11. Hobbies

I59:

Cluster:Python

Interview Questions:

1.self intro

2.how do you rate yourself in python and java

3.generics in java

4.collections in java

5.di erence between set,map in java

6.multi threading, multi tasking

7.disadvantages of multi threading

8.condition for deadlock

9.di erence between left join and left outer join

10.group by in sql

11.di erence between inner join and self join

12.di erence between method and function

13.how to read and print data from excel file in python

14.do you know any other languages

15.how threads are created in java

16.Explain the implementation of your project

17.why have you used these algorithms

18.which libraries are used for creating graphs(visualization)

19.Have you used scripting language like javascript in any web development

20.what is html and mark up language

21.what is css and why it is used

22.can a table have 2 primary keys(composite key)

23.does java and python support multiple inheritance

24.what is your role in project

25.how do you collected the dataset

26.How to create an array in python

27.show me id card and government id proof

Programs:

python code for sum of two numbers and reverse an array

Any queries

I60:

Cluster : Python

1)Self introduction

2) Are you willing to relocate to coimbatore

3)Are you comfortable with any shifts

4) what is Schema , explain?

5) Datatypes in sql

6) DDL and DML commands

7) Drop and Truncate di erences

8) Characters functions

9)View in SQL

10) Sample query which should have var group by having class
11) Write a SQL query to print details of the Students with the FIRST NAME as 'Prem and Sandy
from Student table.

12) Build-in-datatypes in python

13) Immutable mutable di erences with example

14) Tuple & List di erences

15) Write a Python program to find the maximum of three numbers using comparison operation.

16) What is Cloud computing

17) Any questions

I61:

Cluster : Python

1) College ID verification

2) In , exists di erences

3) Self Introduction

4) list tuple di erence

5) Shallow copy Deep copy di erences

6) DML, DDL commands

7) Randomly given 3 tables and asked me retrieve employee names from those tables

8) inner join , left join di erence

9) Exception Handling

10) what are constraints in sql

11) Relationships

12) Are u ready to relocate to coimbatore

13) Are u ready to relocate to anywhere within india

14) Horizontal scaling vertical scaling

15) Cloud Deployment Models

Programs:

1) Write a program to reverse a string

2) Write a program to check a given number is prime or not

3) Write a program for fibonacci series

I62:

Cluster : Python

1)College ID and aadhar verification

2)Asked to show surroundings to confirm whether any one is there to help beside

3)Are you ok to relocate

4)will you join immediately

5) bubble sort

6) in list of numbers check last digit of each number is divisible by 10 or not

7)sql queries based on joints

8)Any questions

I63:

Cluster: Java

1. self Intro

2. About Academic project

3. Write a code method overloading

4. di erent between method overloading method overriding

5. Oops concepts

6. Arrays strings

7. Di erences between char and varchar

8. About css questions

9. Are you flexible to work with any shifts?

0.html based questions about table tags media tags

11. Sql queries two

12. Any questions for me.

I64:

Cluster : Python

1)Self introduction
2)About Final year project

3)Python Tkinter based questions as I used in my project.

3) what is CNN and it's layers

4) Sql functions

5) Di erence between Truncate and Drop

6) Di erence between list and tuple

7) Asked more about project related questions

8) libraries used in project

9) Any questions

Program:

1) swap of two numbers and strings without using temp

I65:

Cluster : python

1.Asked to show clg id card

2. Asked to show the room

3. Self intro

4. What are the libraries used in the project

5. Oops concepts

6. Inheritance and its types

7. Di erence between list and tuple

8. Data types in python

9. Exception handling

10. GET and POST method

11. Sql and commands

12. Drop and truncate di erence

13. Joins in sql and its types

14. What is cloud computing?

15. Cloud deployment models

16. what is subquery and why it is used?

17. What are the services in AWS cloud?

18. CRUD operations

Programs:

1.Program to import a module

2.Code for handle the errors

Any queries

I67:

Cluster: Java

1. self Intro

2. Which programming language you are familiar with

3. Write a code to do binary search on an array.

4. CSS related question

5. Write a java script code to make an function to receive message

6. Aptitude based 2 questions

7. Deepvopy and shallowcopy

8. Are you willing to locate chennai

9. Are you flexible to work with any shifts?

10. Any questions for me.

I68:

Cluster : Python

1)Self introduction

2) project related questions ( How it is used in real time,what is the date base used in it

3)joints definition explanation

4)How can you rate yourself in python out of 5

5) what is a decorator?

6) Di erence between args and kargs

7) given 3 aptitude questions and asked to solve it

8) Are you willing to reallocate to Chennai/ coimbatore

9) Are you flexible with any shifts

10) Are you flexible with any cognizant o ice?

11) Are you flexible to join in the month of May 10 or 15th

12) Any questions

Programs:

Given three sql queries and asked to write the code for it

Write code for the decorator?

Given a list asked to convert that list into sublist and add those find the max and min in that list

I69:

Self intro

Rating of SQL and python

1.What is Docstring

2.What is list

3.Di erence of array and string

4.What is python

5.Types of Hard disk & explanation

6.Joins in SQL

7.normalization

8.elastic load balance

9.Disaster recovery

10.netapp

11.RPM in SSD

12.SAN

13.di set & dictionary

14.public cloud

15.private cloud

16.are you willing to relocate for Chennai or Coimbatore

17.are you ready with any shifts

18.Any queries?

Program:

Write a program to check whether the element in the given list or not.

Write a program to find the count of the given list

I70:

cluster: JAVA

1) skills

2)java features

3)public, static uses

4)can we use first static and then public

5)void vs main di erences

6)can main method overloaded

7)object is instance or not

8)what is object and how is it related to the class

8)do you know associate operators

9)di erences between string and string bu er

10)garbage collection and types of garbage collection

11)In SQL, tell me about joins

12)How to use descending keyword

13)what is the di erence between group by and order by

14)stored procedure in SQL

15)tags(img, video, audio, ancher)

16)are you willing to relocate for Chennai or Coimbatore

17)are you ready with any shifts

18)Any queries?

programming questions: write a program using objects and explanation

I71:

Cluster : Python

1.Self introduction

2.About academic project in detail

3.About Internship done

4.Write a program on count number of vowels in a given string using python

5.Write a program on conversion of fahrenheit to celsius temperature using python

6.Any questions

I72:

Cluster 1: Interview Questions:

1) Asked About Projects?

2) Which language are you comfortable with?

3) Which java version are you using?

4) Di erence between Java 17 and Java 23?

5) What is multi- threading?

6) What are primtive patterns?

7) What is di erence between String, StringBuilder, Stringbu er?

8) Are you comfortable with other programming languages other than Java?

9) Are you willing to relocate to Coimbatore, Chennai?

10) Are you willing to work in night shifts?

Programming questions:

1) program to check if a list of integers have odd or not in java There is a list of integers. In that,
you need to check whether the odd numbers are there or not. If odd numbers are there, provide a
Boolean value true or else false

2) Provided an array of size N that contains non-negative integer, your task is to determine whether
the number that is formed by SELECT digit of all N is divisible by 10. If a number is divisible by 10,
print it, otherwise print No.

I73:

Self intro

Relocation

Shift preferences

OOPS concepts(all are saying the same answers itseems ,so he wanted to listen di erent
answers)

Polymorphism

Inheritance and types of inhertance

Method overriding code and explaination.

Sql code: 2 tables given student, studentaddress, student id is the primary key and acts as foreign
key in another table, join 2 tables and print 3 columns(student name, student id, student address)
of student whose student id=100

I74:

Cluster: JAVA

Interview Questions:-

1) Asked to show college ID card.

2) Asked about my current region/location.

3) Asked self introduction.

4) Asked to explain projects

5) Asked where and how I’ve implemented JavaScript in my project.

6) Asked In and Exist operator di erences.

7) Drop vs Truncate di erence

8) inner join vs left outer join.

9) indexes in sql

10) what is arraylist

11) final keyword definition

12) how would u Rate your knowledge in java out of 10?

13) how is java platform independent?

14) exception handling

15) try catch blocks

16) encapsulation

17) inheritance meanings

18) In java how inheritance will be used. And where we will be able to find it?

19) collections in java

20) what is interface ?

21) check, uncheck meanings

22) == and .equals() di erences

23) what is threading in java

24) some advance sql and java questions

25) Palindrome definition with an example

26) why mechanical to IT?

27) have anyone asked you to pay money throughout cognizant hiring process?

28) are you willing to work in any shifts ?

29) are u willing to relocate anywhere across India ?

30) are u willing to join immediately ?

31) willing to learn any new technology present at cognizant

32) any questions

Programs:-

1) find Palindrome of a number in java (and explain the logic of the code)

2) Find palindrome of a number using strings in java.

I75:

Cluster: JAVA

Interview Questions:

1)self introduction

2)which language are you familiar with?

3)explain oops concept?

4)About collection frame work.

5) Di erence between arraylist and linkedlist.

6) Di erence between final,finally and finalize

7)what is exceptional handling.

8) Di erence between throw and throws.

9)what are joins in sql.

10)Are you flexible in learning new technologies.

11)willing to relocate.

12)willing to work with any shifts.

13)willing to immediate joining.

Program:

1)write a program for swapping two numbers.

2)factorial of a number.

3)write a query to select 2nd highest salary .

4)write a query to update the salary when employee id is 1.

I76:

Cluster: Python

1. Did anyone asked money throughout the process of CTS hiring (No)

2. Are you willing to relocate to Chennai/ coimbatore

3. Are you okay to do rotational shifts if possible night shifts

4. Introduce yourself

5. About the final year project and the models used in the project

6. What is sql

7. 2 Sql queries on employees table

8. Joins in sql

9. Di erence between inner join and left join

10. Datatypes in python

11. Mutable and Immutable objects in python

12. Examples for mutable and immutable

13. Lambda Functions in python

14. Print square of a number using lambda function

15. Code for printing the given pattern

I77:

Interview questions

Cluster: JAVA

Interview Questions:

1)Tell me about yourself

2)What do you know about Java and it's features.

3) what is polymorphism?

4) Types of Polymorphism

5) what is the compile time and run time?

6) SQL joins explanation.

Program:
1. SQL query on students table using joins

2. Implementation of polymorphism example

(With specific return type)

I78:

Cluster : java

1.Self intro

2.Oops Concepts in depth

3.language used in Project

4.exception handling.

5.finally

6.constructor

7.Try, Catch means what

8.what is abstraction

9.what is Custom Global Exception Handler

10.what are decorators

11.what is encapsulation

12.what is primary key

13. Do primary key contain null values

14.What is foreign key

Program :

Write a program for inheritance

Sql queries - 2

Any queries?

I79:

Cluster: Java

1. Self intro

2. Language and model used in project

3. In which language you solved questions in the exam(Java)

4. Why java is platform independent

5. How it is platform independent

6. Do you know MySQL

7. Inner join and left join

8. In and exist di erences

9. Arraylist or linkedlist fast

10. Why and how it is fast

11. Rate yourself in java out of 10

12. Collections in java

13. Di erence between set and map

14. Exception handling

15. Finally

16. Can try block contain many catch blocks(Yes)

17. How many it will contains

18. Encapsulation and it's benifits

19. How it will be useful.(Encapsulation)

20. Inheritance brief

21. Do you know palindrome (Yes)

22. Write a code for palindrome string

23. Palindrome for number

24. Did anyone asked money throughout the process of CTS hiring (No)

25. Are you willing to relocate to Chennai/ coimbatore

26. Are you okay to do rotational shifts if possible night shifts

27. Are you okay with any technology

28. Any queries.

I80:

Cluster:python

1. Introduce yourself include only certifications and internships

2. Which language are you comfortable with

3. What are python data types

4. Write a program for even or odd number

5. In the above program add one more condition that print if the number is 10 Else check the given
number is even or odd

6. Write a program for sting reverse

7. Write a program to find Max value in the given list

8. Tell me about any two joins

9. Provided me a table and asked to write a query to delete delete a record.

10. Tell me about your cyber security internship

11. Which one do youser among the following application ,AI or Coimbatore

12. Willing to join immediately

13. If the project is related to the another technology Java or .net will you ready to learn new skills

14. Any questions

I81:

Cluster: java

Interview Questions:

1.Are you willing to relocate

2.Are you comfortable with any shift

3.Self intro.

4.write the code to reverse a string without using reverse method in Java.

5.Why you have written print instead of println in the code.Explain. ( I have used print statement
in the code)

6.Given a series of numbers and asked me to find out the next number In series.

7.Explain OOPS Concepts?

8.What is the di erence between final, finalise, and finally.

9.What is the base class of exception

10.What is jvm and what is the use of it?

11.What are the datatypes and explain each of them in detail.

12.What is di erence between string and string bu er.

13.Explain what is n type semi conductor.

14.Explain what is p type semi conductor.

15.what is MOSFET and tell it's working?

16.Explain some SQL statements

17.How can we overcome exceptions in Java.

18. What are access modifiers

19.given another series of numbers and asked to find out next number again?

20.Given a puzzle and asked to solve.

21.Any questions?

I82:

Cluster: java

Interview Questions:

1.Self intro.

2.About final year project?

3.Di ernce between java and python?

3.What is meant by SQL?

4.Questions about Core subjects.

5.Explain OOPS Concepts?

6.About SQl Statements.

7.Role in project.

8.Write a program in the language you are familiar with?

9.Are u willing to Relocate?

10.Any questions?

Programs:

1.Asked to write a program to print prime numbers?

2.Sum of two numbers?

3.SQL query on Student details?

I83:

Cluster : Java

Interview Questions:

1. Self intro
2. Data science vs ai-ml

3. About projects

4. Count no of elements code

5. Sqlcommands

6. Access specifiers

7. DSA

8. Queue and stack di erence

9. It's implementation

10. Oops concepts

11. Abstraction and polymorphism di erences

12. Inheritance types

13. Primitive data types in java

I84:

Cluster:python

Interview questions

1) Introduce yourself

2)what is oops

3)what is encapsulation

4)what is abstraction

5)are you willing to relocate to Chennai

6)are you flexible to work with other programming language

Program

1) write a code to find factorial of a number( twist even if you are python cluster they are asking to
write code in Java)

2)code with handling negative numbers for factorial

I85:

Cluster:Python
Interview questions:

1.Self intro

2.About projects

3.Project implementation

4.Project libraries

5.Why Django?

6.Why python?

7.sql vs nosql

8.What other than python you are comfortable

9.Can nosql use database

10.Which data base used for nosql

11.what are these(list in py) called list or array?

12.primary key vs foreign key

Program:

Situation based

I86:

Cluster: JAVA

Interview Questions:

1) When can you join if we hire you?

2) Are you ok to relocate to Banglore or Chennai?

3) What is your preferred language?

4) Self Intro

5) What is JVM, JRE, JDK explain di erences.

6) What is String pool?

7) Types of Packages

8) Datatypes in java

9) Wrapper Class

10) print() vs Println() vs printf();

11) Explain types of Operators in java

12) Explain types of Arrays in java

13) What is Encapsulation?

14) Main Advantage of Encapsulation.

15) Inheritance and Types of Inheritance.

16) Problem with multiple inheritance and how to implement it.

17) Explain interface.

18) Di erence between StringBu er and String.

19) What are class variables.

20) What is static and how it is actually help us in code.

Program:

1) Write a code to check if the number is prime or not. Use static in it.

2) Implement Fibonacci series and print.

I87:

Cluster: java

Got interviewed for the python

1. Self intro

2. Interviewwer introduced himself

3. Ask me which language I am familiar with

4. Ask about favourite core subject and why?

5. Write a code to find the number of time the given character is repeated and return the count
and the index positions also.

6. And Is there any queries to ask..

I88:

Cluster:python

Self intro

Why python

Count number of "a" in given string

Write a code to find the sum of all the even numbers between 11 to 99

Join quires inner join

DDL statements

Any location any shift

What is ohms law

Diode

I89:

Cluster: Python

Self introduction

Asked my preferred language(Java)

Code-display 3 college names

What is Java and its importance

Java components(Jdk,jre,jvm)

Java latest version and what I am using

Packages-importance and examples

Datatypes and its default values

Local variable vs instance variable system.in,system.out,system.err

Detailed explanation of oops and Asked questions on oops topics

SQL

What is sql

5 Types of sql commands

CRUD operations

Table and fields

Foreign key vs Primary key

DBMS and its types(SQL,No SQL)

Any questions?

Are u willing to relocate to coimbatore?

I90:

Cluster : Java

Interview questions

1. Self intro
2. which version are you using in java

3.Di erence between Java and Java 8

4. Java features

5. Lambda expressions

6. what type of interfaces do you know

7. What will happen if we don't use @override

8. Explain the multi threading life cycle

9. Define wait and sleep methods

10. What is Functional interface

11. Do you have an idea on the stream APIs

Program: Asked to write a program to print Yes or No if the last digit in array elements will be
divisible by 10

I91:

Cluster: java

Introduction

Project

SQL joins

Exception handling

Finally

Binary search program

Finding second largest number

SQL queries:

Print all elements

Fetch emp data salary>10000

Print first 10 emp details

I91:

Cluster: python

Interview questions

1. Self intro
2. About project (Algorithms)

3. Java concepts (inheritance, polymorphism, abstraction)

4. What is abstract class

5. Di erence between abstract class and normal class

6. Java operators

7. Python features

8. List,set,tuple, dict explanation

9. Explain inheritance and polymorphism with example

10. About AWS cloud as I mentioned in resume

11. Are you ready to join immediately

12. Are u ok to learn any new technologies

13. Can you relocate to coimbatore

Program : Asked to write program to print prime numbers form 1 to 100

I92:

CTS Interview Completed

1. TELL ME ABOUT UR SELF.

2. SWAPING PROGRAME WITHOUT TAKING 3 RD VARIABLE.

3. QUERY TO CREATE DATABASE

4. HTML SKELTON CODE

5. SYSTEM.OUT.PRINTLN EXPAINATION

6. PUBLIC STATIC VOID MAIN

5. PROJECT AND RELATED QUESTIONS

6. RELOCATION YES OR NO

7. SHIFT TIMINGS