Infosys Software Engineer Trainee interview questions

Technical 1 Q.1) What are joins, explains it's types. I was given a table and was asked to draw all different types of joins Q.2) Pattern based questions Q.3) Difference between Drop Delete Truncate Q 4) Explain Angular Typescripting, components Q.5) Primary key vs unique key Q.6) Query based on GROUP BY clause. Q.7) If I join the table and want to convert the null values to default 0, how can I do it? Q.9) All about my internship project as my project consist of database optimisation he asked me how did you do that as they were very interested in any SQL based project. Managerial Round Q.1) What did you learn from previous interviews? Q 2) Code for getting last word of a statement Q.3) Code for traingle pattern Q 4) Rigorously asked about my project, specifically database related projects. Q.5) Queries on ORDER BY and JOINS Q.6) Normalisation

What is object oriented programming structure?