CGI Software Developer interview questions

It took a couple of months, fairly simple process. Recruiter Call (virtual): A little about myself and why I became interested in programming. Why do I want to work at CGI? What do I want my career to look like in the next few years? What are 3 strengths of mine? CGI first round (virtual): What is a primary key and foreign key? What is inheritance? How would you find out how many cars are driving on the road right now? What are joins? Can you name the type of joins? Resume questions (tell me about your role at internship, questions with Final technical (in person) Questions about projects Tell me what OOP is and why it’s important Create an object with certain attributes and methods (setters, getters) Tell me the 4 pillars of oop (and examples of each on whiteboard) Queries to to add, delete, update, and look for information with sql The different sql joins (inner, outer, right, left cartesian join) Primary key and foreign key Relationship between tables (one to one, one to many, etc.) Demonstrate many to many with sql Final Behavioral Resume questions (tell me about this experience) Conflict with coworkers question Where do you see yourself in 1, 3, 5 years?