FDM Group interview questions

Behavioral Interview: - How did you overcome your weakness? - What do you know about the specific role you applied for? - How would you prepare if you were going to learn a new technology the next day? - What do you think about the 2-year program? - Will you be willing to relocate? Technical Interview: - What is a static variable? - What does the final variable in java? - What is runtime polymorphism? - What are pass-by-value and pass-by-reference? - What is the final method in java? - How would you achieve data abstraction in java? - What is an abstract class? - What is the difference between an array and an array list? - Given an array of int, how would you find the repetitive number? - What is the complexity of that algorithm? - What is a foreign key? - Can a foreign key contain a null value? - What are other constraints required in a foreign key other than null value? - What are some conditions for joining two tables? Given a table, how would you perform a join? write a query to show all employees with salaries greater than 10000 write a query that shows avg salary of the individual department.