Where is Desc <table> or conn <username>/<password> check

Hello DBAs,

I am a student OCP.
I want to where does oracle check

Desc <table> or conn <username>/<password>

Do these entried go in Library Cache/Dictionary Cache or Data Buffer Cache or Redo Log Buffer Cache or in UGA and where does Oracle check validation on these entries.

Why it accepts desc/descr/descri/describ <table> eventhough everything is for same purpose

Can we give shortcuts like these in any user define query

Pls help and send answer
Thank You Received on Sat May 06 2006 - 13:23:38 CDT