Teradata Interview Questions, Process, and Tips

Interview preparation tips for other job seekers - Do prepare from leetcode for DS and algo, as all of my questions can be found among the first 20 problems in each of the above categories,I.e stacks, queues, trees and graphs.

Interview preparation tips for other job seekers - Give detailed summary about your past role

Round: Test
Experience: Aptitude, os , c, c++, data structure and Algorithm

General Tips: If you want to get job try smartly impress your recruiter with your fact full answer and stay calm . Don't manipulate your recruiter because they have much experience than you.
At last if they said, ask any questions from me don't ask about their salary and how many years of experience they are having. It's my personal experience I asked one recruiter about their salary and their experience then what they said to me I can't share here.
Skills: Communication, Problem Solving, Analytical Skills, Time Management, Decision Making Skills
Duration: <1 week
College Name: NIT Trichy

Round: Test
Experience: I had a hard time taking out time to prepare because of the TnP work so I concentrated solely on campus preparations throughout the summers apart from PC work and left out my project work. I worked out a little from the GATE practice book, programming questions from “Exploring C”, and rest from “Coding Interview Questions” book by Karumanchi. These 3 books were all that I read or prepared to some extent and found them sufficient for covering up all the points in detail
Tips: A combination of strong basics in your subjects, good projects and club activities can help you bag possibly any good job. My only suggestion would be to not restrict yourself to grade studies. Also, spend time productively in the campus, be it coding, sports, clubs, etc..

Round: Technical Interview
Experience: For technical rounds, I practiced my subjects from the books mentioned above, though I dint practice aptitude questions much due to lack of time and interest. I also brushed up on my internship projects for the interview rounds since we tend to not remember them in details. For the HR round, I just tried to be as genuine as possible.
Tips: For a CSE student, there is no dearth of opportunities and companies coming up, but the major challenge is the amount of pressure that builds up subsequently. Initially I missed out on a few major companies like MS, Dell and Novell. Also, being a PC, I was missing out on a lot of preparation time.

Round: HR Interview
Experience: My placement season was short which is a bit relieving as now I can concentrate on my project work and placement coordinator work. Every written test and interview were a great experience. There were a lot of frustrating times when a program dint work out or I missed some round by a small margin, but then I tried keeping faith in my abilities and tried to move on. My parents and friends helped me out a lot to get back up every time things weren't working out. At the end of the day, if you have worked hard to achieve something, you will definitely get it at the most opportune moment.

General Tips: I got a dream offer from Unisys and a super dream offer from Teradata&#44; on 8th Aug. I am satisfied with both the companies that I am placed in. I would personally prefer Teradata because of better research environment there, the job entry level and pay package.
Skill Tips: I got a dream offer from Unisys and a super dream offer from Teradata, on 8th Aug. I am satisfied with both the companies that I am placed in. I would personally prefer Teradata because of better research environment there, the job entry level and pay package.
College Name: NIT ROURKELA
Motivation: A combination of strong basics in your subjects&#44; good projects and club activities can help you bag possibly any good job. My only suggestion would be to not restrict yourself to grade studies. Also, spend time productively in the campus, be it coding, sports, clubs, etc..

Round: Test
Experience: NCR Interview Questions
This is a list of questions I faced in an interview at NCR TeraData for a technical position of software engineer. Mined you it was not for a fresher opening. I hope this help for the experienced persons in C, C++ and UNIX.Introduction questions:
1.Tell me about yourself? 
2.What is your project all about? Tell us about the application architecture? 
3.What was your role? Which part of your project you are involved in? 
Specific to project:
1.Where did you use the concurrency? 
2.When is concurrency introduced in the application (When the threads are created)? 
3.How do you synchronize multiple requests for multiple Work stations? 
4.Why separate thread is created for reading and writing? 
5.How do you read and write (Which function do you use) if there is only one thread for reading and writing? 
6.To which operation you give priority, read or write if a socket is read for reading as well as writing? 
7.If read is given priority where do you store your data to be written? 
8.How much comfortable you are with C, C++? 
9.How do you rate on the scale of 10 for C? 
10.Which compiler did you use?

Round: Technical Interview
Experience: Technical Questions:
C:
1.What is select? 
2.What is poll? 
3.How do you create thread? 
4.Which library you link with when you use pthreads? 
5.How do you create process? 
6.How many times fork() returns? What are the values? 
7.What is the difference between fork() and exec() system calls? 
10.Do you know readers writer problem? 
11.Take a data structure and synchronization mechanism and solve (write code for) the readers writer (in fact they asked for multiple writers)? 
12.Why did you use while instead of if when checking for the full/empty condition (in solution to the readers writer problem)? 
13.What are the differences between a process and a thread? 
14.What are the things that thread doesn’t share with process? 
15.Why there is separate stack for each thread? 
16.What is fopen? 
17.What is the difference between fopen and open? 
18.What is the difference between high level functions and low level functions? 
19.What open returns? 
20.Descriptors returns by the open will be in sequence? Justify? 
21.Why open doesn’t return 0 or 1 or 2? 
22.How do you find size of a file? 
23.What is fstat? 
24.What are different options available with cc 
25.What an output files contains? 
Database Concepts:
1.What is RDBMS? 
2.What is referential integrity? 
3.What are ACID properties? 
4.What is a transaction? 
5.Relate atomicity in transaction definition? 
6.What is a primary key? 
7.What is a foreign key? 
Data Structures:1.Do you know data structures? How far? 
2.Do you know Binary tree? 
3.Write a code for changing a tree into mirror image of itself? Trace it for given input? 
4.Do you tree traversal techniques? What are the different traversals techniques? 
5.Do you know binary search trees? Explain? 
6.Arrange the given input (sequence of numbers) in to a binary search tree? 
SQL:
1.Write a query to display average salary of all employees in EMP department number wise? 
2.Write a query to display average salary of all employees in EMP department name wise? 
3.Write a query to delete a row from a parent table if no related row is present in corresponding child table? Take example of EMP and DEPT tables? UNIX:
1.Tell about virtual memory and paging? 
2.What is fragmentation?
3.Do you know UNIX internals? 
4.What are makefiles? 
5.Write a small sample makefile? 
6.Which debugger did you use? 
C++:
1.How virtual functions concept is implemented internally? Explain with short code? 
2.What are pure virtual functions? 
3.When do you use pure virtual functions? 
4.Where do you use dynamic_cast? 
5.What is RTTI? 
6.How do you identify the type dynamically? 
7.What are the other casts available in C++? 
Shell Script:
1.How to print number of users logged in? 
2.How to print status of all processes? (Whether running or done)? 
3.How do you print the status of a given process given the process id?

Round: HR Interview
Experience: HR:
1.How was the technical interview? Difficult/Normal/Easy/Worst? 
2.You scored very less in written test, why? 
3.What is your current CTC? How much you are expecting? Can you justify? 
4.How much time do you require to join if we give you offer?

College Name: NA