I just passed my first OCP paper SQL@PLSQL. I should say it was not that easy. Just managed to get 43 out of 57. I have one year experience on Oracle. One question just puzzled me. In which situation is a projection used??
I have already booked for the Database admin Paper. How is this paper like. I am using Jason Couchman's book and I have some 300 STS question is this enough.
PROJECT is a relational operator that retrieves a subset of columns from a relational table, creating the result set after removing duplicates.
basically Projection are selects + distinct, I didnt learn this from Oracle ILT resources, nothing abour projection is mentioned. Got taught about projection in college :D