If you want to know more on these topics, you can look in the Oracle9i SQL Reference and Oracle9i Concepts manuals on http://tahiti.oracle.com.