is it half mcqs and theory or full theory(as in written sql code)?also,is doing past papers from one search a good practice?(also is boyce codd form and tree based indexing included in the topics we need to know?)

there's no MCQ, apparently the exam follows the same format as the practise exam which is uploaded to lecture slides tab (on LMS) down the bottom in week 12. You can watch October 9th lecture from 49 minutes onwards to follow along with UC explaining the practise paper. any practise is good practise, but also, as far as I'm aware, the format for this years exam will be different to previous years, so if you only have little time, I'd invest more of that into the practise exam as opposed to previous years paper. as for Boyce code form and tree based indexing, I'm not sure sorry.