Partner Sites
CTS Interview Questions
Technical interview Questions:
1) Give me an example of data types? (but they use a different word for it so be ready)
2) How many files can be declared in CL and SYNON
3) Give real world examples of different types of data structures.
4) Describe database tuning
5) Describe Informatica Performance Tuning process
6) What do you understand by Garbage collection?
7) Write the syntax of finalize?
8) What is the difference between finalize and finally?
9) What is the difference between string and string buffer class?
10) What is the use of virtual classes in C++?
11) Why virtual classes are important in the case of multiple inheritances?
12) How Databases handle concurrent SQL operations on same row of a table?
Ans:Concurrent operations are handled by the use of "Locks". To be more clear, if one sql query is updating (INSERT/UPDATE) a particular row of a table, no other sql query would be able to update the same row at same point in time. However other sql queries can read (SELECT) columns from the row under updation.
13) What is the simple difference between stack and queue type data structures?
Ans:Stack operates in a Last In First Out (LIFO) fashion while Queue operates in a First In First Out fashion (FIFO).
14) Real life examples for stack and queue ?
Ans:Plates arranged one over the other in hotel is an example for stack. Plate that was placed last on top will be the first one to be removed from the stack.
Queue in billing section of stores is an example for queue.
15) Tell at least two uses of NORMALIZATION in designing tables and other structures in a database ?
Ans:Normalization ensures that a) there is no redundant data storage and b) data dependencies across tables (foreign keys) are suitable for the level of concurrency.
HR Interview Questions:
1) Tell us something about yourself.
2) Why do you consider yourself a suitable candidate for this position?
3) What do you do to improve your knowledge?
4) Can you perform under pressure?
5) Tell us some of your strengths.
6) Tell us some of your weaknesses.
7) Are you comfortable working in a team?
8) What are your experiences in teams and how do you problem solve?
9) Why do you want to work at cognizant?
10) What do you do on your free time?
11) What are you passionate about?
12) What is your style of management?
13) How do you deal with teams?
14) Describe in brief about your past project
15) What position would you prefer while working on a project?
