Oracle Key Concepts - Make Sure You Know All!
The content taken from
Title: Oracle Database Administration Concepts &
Implementation Made Simple
ISBN: 0-9770739-0-4
Author: Asim Abbasi
Oracle Key Concepts - Make Sure You Know All!
Oracle Key Concepts - Make sure you know all especially before appearing for Oracle Certification (i.e. to becoming Oracle Certified Professional or OCP)
1. Oracle Database Server is comprised of two things
a. Instance
b. Database
2. Anything that is going into the database or coming out of the
database has to be through Oracle Instance.
3. Oracle Database is encrypted and we cannot read it through any Text
Editor like MS Word.
4. SQL commands are used to store and retrieve information.
5. Each connected user with Oracle Instance is considered as “Session”
6. Never forget the concept of following three terms
a. Instance
b. Database
c. Session
7. Following analogies help you in building concept
a. Instance = Genie
b. Database = Notebook
c. Session = Aladdin (or connected Users)
8. To communicate with Oracle Instance we need to learn SQL.
9. Users can connect to Oracle server independent of their location.
10. Oracle Server: When we talk about Oracle Instance & Oracle Database
collectively we use the word Oracle Server.
Oracle Key Concepts - Make Sure You Know All!
Share with others: