Oracle Technical Solution Analyst interview questions

I applied though LinkedIn. Got a call from recruiter after a week. First was a Versant Round, basic english & communication skills. First Technical Round was scheduled on 23rd Jan 2023. It was a video interview with the project lead. Interviewer was very nice and gave a brief description of the project, team & job profile. I was asked about my previous job role. Difference between primary key and foreign key, views Query on left join, inner join, nth highest salary, agg functions Second Technical Round was scheduled after a week and was taken by Project Manager, he was very nice & welcoming. He asked me about my previous job role, why I left the company & basic situational questions. sql query on Count, join on 1st Feb 2023 recruiter informed all rounds are cleared and they are preparing to release offer letter. Got the offer letter after 22 days. Since Cerner is now Part of Oracle, it takes time to release offer letter.