12th November TCS Ninja 2021 All Interview Question with Real Experience

   

12th November TCS Ninja 2021 All Interview Question with Real Experience

12th November TCS Ninja 2021 All Interview Question with Real Experience:

Hello Everyone,

In this post, I am going to share the Interview experience for TCS NQT 2021.

Now Start my Blogs:

I've cleared the TCS National Qualifier Test(NQT) by attempting all two questions related to programming.

3 panelists 1HR 1TR 1SR(senior guy)

TCS Ninja Interview Question

Technical Round (TR) Questions Asked During Interview: 

Saw my resume and said I see you have mentioned Data structures and SQL in your skills sections (he took these 2 out of 6 skills that I have mentioned) 

Which topic would you like to first

I told him Data Structures

1. Linear and non-linear ds. 

2. What is a binary tree why is there a need to use a binary tree

3. Why do we need BST 

4. Explain all traversals 

5. Gave a tree told to write down all the traversals of it

Done with Data Structure and Algorithm

Now Switched to SQL

1. What are views and materialized view

2. Can we do indexing on views

3. How would you tune a SQL query

4.Told me to create a trigger 

Had Discussion on that trigger

5. Gave a scenario:- 

I have a trigger that fires on the insert, update and delete now you have to limit that trigger to only fire when there is an update using if

6. Difference between function and procedure?

7. Deep discussion on having group by and where clause (advanced question fired from his side)

About The Post:

In this Post, All Students get to know all the information about upcoming interviews who is still not received Ninja Interview Dates so prepare these questions All the best. and anyone has any questions related to this post you can reach to me or comment on this post you will get a response as soon as possible.