I have an interview in UBS in May 2021 , Firstly they will shortlist your CV if it matches with their requirements then the first round will be the Technical round by AVP. They will ask you questions as per your year of experience in the Oracle PL-SQL , SQL & UNIX shell scripting. He or she will fire you questions as per the ranking you give for the particular skill out of 5. They will find out if the candidate who will strong in basics of PL-SQL as well as advanced PL-SQL, performance tuning, Bulk collect, Indexing and partitioning . Most of the questions were scenario based. Below are the questions for your reference.