Reading the fine Oracle® Database Concepts would answer all your questions.