Hi: I'm preparing for the 1Z0-047 exam. I'm well versed in all the exam topics listed on Oracle's corresponding cert page. However, there are many more SQL topics from which exam questions could come. For example... - Use of the MODEL clause - XML functions - Creating functions, procedures, and packages Can anyone share their experience about what questions, if any, came from these or other exam topics they encountered? Trying to keep the surprises to a minimum (yeah right). Thanks for your help.