Persistent Systems Graduate Engineering Trainee GET interview questions

Questions for technical round: Introduce yourself. What are references in C++? What is the difference between new and malloc? What is difference between class variable and instance variable in Java? Does Java support pointers? What is used in place of Pointers? How to calculate no of records in a table in SQL. How to print all records in SQL How to create table with primary key What are constraints? (Types pan sangitle mi) What is primary key? What is the difference between primary key and unique key (Tell the main differenciating factor) What are joins? What commands have you used in Linux? What is grep command? (How is it used) Write code for fibonacci series in java.

What is Stack? What is Deadlock? How does a search engine work? (Behind the scene, requests, DNS etc.) Without using temp variable, exchange value of 2 numbers. What are Linked lists? Basic SQL commands (Order by, RANK)