Actually failed it the first time by 2 questions, it's one hard test, and SQL doesn't hold my interest as much as programming languages. Barely squeaked through part 1 for that matter. To add insult to injury, the test cost just increased from $195 to $245.
Definitely use the official study guide and do lots of practice. Lots of little minutia come up in questions. I created a set of 20 exercises that covered the basics of the 11 chapters and kept practicing them until little peeking was needed. Did not review the part 1 material, and did not seem needed. Still good to stay up on if time permits. The list of study topics on Oracle's website was fair.