It varies upon the state. California is pretty lenient -- I've seen people actually cheat on the written tests (10 true false questions!) and not be called on it. Some don't even have a driving test!

In AZ, I had to take a long form multiple choice test of 40 questions plus a 30 minute practical demonstrating my understanding of the dimensions of the car, parallel parking, urban, highway, and rural driving.