Teradata Interview Experience | Set 4 (On Campus – Feature Testing Role)

Written Test

• MCQs on Coding (predict the output, identify the error, …), Operating System

Technical round -1

• If a linked list has a cycle
• OOP concept, with examples
• Prime number, fib series, reverse str (iterative, recursive)
• Some SQL Queries.
• ACID properties of DB Transactions.
• Some puzzles and logic questions.

Technical round – 2

• structures:

  struct t{
  int a;
  int b;
  };
  t c[100] = {{1,2},{3,4},{5,6}. . . . };
  t *tmp = (t*) &c[1].b;
  tmp->a=100;
  tmp->b=200;
  

Answer and explaining what values changes

• Binary search – input array is either ascending or descending, detect and do search! (give most optimized sol possible).
• 240 students marks list is given.Generate the report and marks count of students
  0-10 – ,
  11-20
  .
  .
  .
  .
  91-100

Give a solution, use any DS if you want, give optimize solution!
-> After i gave answer with hashing, hash function calculates upper bound and lower bound, so extended question on that for bin size 0-5.

• Given a list of names of unknown length, store them dynamically in contagious locations
• Talk about different databases in market (as I had mention of MongoDB in my Internship Experience)
•  Talk about NoSQL Database and SQL databases (since I gave him few reasons why I found MongoDB more cool over SQL database over some areas).
• Questions on Internship Experience, schooling, College. Casual one on one talk about their company, asked me if I’ve any questions to ask.

HR Round – 1
HR Round – 2
If you like GeeksforGeeks and would like to contribute, you can also write an article and mail your article to review-team@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above

My Personal Notes arrow_drop_up

Save