Teradata Interview Questions, Process, and Tips

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