Question

Cognizant | Interview Experiences | Programmer Analyst trainee | [2022] | Set 1

Answer 1

Firstly there was an assessment held on MSB and there were two sections and a total of 5 questions.

3 programming Question & 2 SQL question. Both sections were Average.
I was able to solve 2 programming questions and 1 and a half SQL questions. and was selected for the interview round.
People who solved 1 programming question and 1 SQL were too selected.
Now the interview was scheduled on Superset from 3 pm to 4.30. My interviewer joined at 3.05 and the interview went on till 3.55 pm.

Questions were:

Id
Where are you from
Stream
Intro
Waterfall model
Domain language?
Slicing
Pickling
Lambda
Call by reference
Is it call by reference in python?
Call by value
Write a code for the call by value
Explain your code
What does Len function do
Do you know DBMS
Acid properties explain all
Normalisation
2 normal form
Write a SQL query to print a unique name from the table.
Truncate vs delete
Write a SQL query to print the duplicate names from table
One more question didn’t know. question too don’t  remember
Foreign key
Super key
Types of join
Write SQL query to print names which occurred maximum no. Of times.
Candidates key
Schema
Two Apti question was asked like 3,7,15,31,?,127.
Will you work any shift
Are u willing to relocate
Preferred location
2nd preferred location
Will you work on any technology
Do you have any questions
After 10 days I got the list of people who were selected by my TPO.