I passed all of mine first time (L-plates, Provisional 1, Full License).
The Learner test is just a sign-recognition road-rules knowledge test. I decided to do one-last-practice on their website before I went out to do it, and got a battery of sign questions I hadn't seen before. I got several wrong on the practice, but then the actual test had those same ones in it so I passed.
My Provisional license test is a driving one; you normally have to do two or three manouvres, like reverse parking or three-point turns. You need to have logged 50 hours of driving time on your L-plates, and as it turned out the last lesson I had at 7-8am (my test was at 9am) just took me over the 50 threshold.
I actually broke the speed limit (instant fail) and still got my license; we'd been driving around for a while, and I'd only done the reverse park and a hill start, and she said "Okay, time to go back". I thought I must have failed already since we hadn't done the three-point turn. The road she directed us to was this long, steep, downhill road that leads into town right near the RTA office, but we got onto that road by driving up a perpendicular street that was uphill really steep. When I tried to turn onto the main road, I had to accelerate up the hill and turn sharply, and in doing so I hit the downhill section and my speed jumped to about 60-65kph, when the limit was 40kph. She said "Watch your speed", and my heart sank. It took us a minute or so to get back to the RTA and park, so I went inside fully expecting to fail.
To add more drama - my Learner's license expired in three days, so if I failed I would need to renew my Learner license. Even worse - under the new learner license regime, all new licenses need 120 hours of driving logged.
I went up to the counter, and she said "Congratulations - you're very lucky." As it turned out, the speedometer in my car is sunk into the dashboard. Consequently, if you're short and in the passenger seat as she was, you can't see the left side of the speedometer. As she couldn't write down what speed I was going at in that 40 zone, she couldn't penalise me for it. (I think it helped that I'd driven perfectly up to then, and it was right at the end of the test).
The full license test is a hazard-perception one. You basically get shown a series of videos, and you have to press the screen when it's safe to turn right, or when you would slow down. Basically, you just be super-duper extra cautious, and you can't fail.