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