Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Oracle Basic Concepts

By: FYIcenter.com

This is a collection of 17 FAQs for Oracle DBA on fundamental concepts. The clear answers and sample scripts provided can be used as learning tutorials or interview preparation guides. Topics included in this FAQ are:

  1. What Is Oracle?
  2. What Is an Oracle Database?
  3. What Is an Oracle Instance?
  4. What Is a Parameter File?
  5. What Is a Server Parameter File?
  6. What Is an Initialization Parameter File?
  7. What Is System Global Area (SGA)?
  8. What Is Program Global Area (PGA)?
  9. What Is a User Account?
  10. What Is the Relation of a User Account and a Schema?
  11. What Is a User Role?
  12. What Is a Database Schema?
  13. What Is a Database Table?
  14. What Is a Table Index?
  15. What Is an Oracle Tablespace?
  16. What Is an Oracle Data File?
  17. What Is a Static Data Dictionary?
  18. What Is a Dynamic Performance View?
  19. What Is a Recycle Bin?
  20. What Is SQL*Plus?
  21. What Is Transport Network Substrate (TNS)?
  22. What Is Open Database Communication (ODBC)?

Descriptions of some key concepts are based on Oracle documentations.

(Continued on next topic...)

Oracle Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...