Intercontinental Exchange Risk PL/SQL Developer interview questions

Applied online. Got an email for video interview. There were set of six prerecorded questions. Three of those were about how I am good fit for this position, why I am interested in this company and this role, etc. Rest three were of technical questions, more as of writing answers for exam paper. One question was to find out what errors will be generated from the given code and how the code can be corrected to get rid of those. The other one was to write some complex query.