CVS Health Data Scientist Intern interview questions

HireVue Interview and they asked very basic SQL questions like below: What is a join in SQL? What is the difference between inner join and outer join? What is a subquery in SQL? What is the difference between DELETE and TRUNCATE in SQL? What is a view in SQL?

The interview process consisted of three rounds. The first round was a video interview, followed by a technical interview in the second round. The third and final round included back-to-back interviews, one focused on business and problem-solving, and the other technical in nature. The recruiter provided me with information about each stage of the interview process, allowing me to prepare accordingly. The interviewers were all friendly and professional, and they were willing to help and clarify any questions I had throughout the process. Overall, the experience was very positive, and I gained valuable insight into the company and the role I was interviewing for.