Not being funny but it's a SQL exam...
DDL (index creation, table altering, view creation), queries with grouping, various join types is what you would expect, no? If it's as bad as Oracle's SQL exam it would probably include lots of generic functions that are used once in a blue moon but somehow make it into the exam~
no idea about "windowing" or xml though 😡
Dird