Summary OCA Oracle database 11g : SQL fundamentals I exam guide (exam 1Z0-051)

-
ISBN-10 0071597867 ISBN-13 9780071597869
7 Flashcards & Notes
0 Students
  • This summary

  • +380.000 other summaries

  • A unique study tool

  • A rehearsal system for this summary

  • Studycoaching with videos

Remember faster, study better. Scientifically proven.

This is the summary of the book "OCA Oracle database 11g : SQL fundamentals I exam guide (exam 1Z0-051)". The author(s) of the book is/are John Watson, Roopesh Ramklass. The ISBN of the book is 9780071597869 or 0071597867. This summary is written by students who study efficient with the Study Tool of Study Smart With Chris.

Summary - OCA Oracle database 11g : SQL fundamentals I exam guide (exam 1Z0-051)

  • 1 Oracle Server Technologies and the Relational Paradigm

  • Oracle Enterprise Manager:

    Oracle Enterprise Manager comes in three forms:

    Database control
    is a graphical tool for managing one database, which may be a RAC clustered database.

    Application Server Control
    is a graphical tool for managing one application server instance or a group of instances.

    Grid Control
    globalizes the management environment. A management repository ( residing in an Oracle database ) and one or more management servers manage  the complete environment: all the databases and applications servers, wherever they may be.

  • Oracle Application Server:
    The Oracle Application Server is a platform for developing, deploying and managing web applications.
  • RAC ( Real Application Cluster )
    Oracle RAC allows multiple computers to run Oracle RDBMS software simultaneously while accessing a single database, thus providing clustering. One database can be opened by many instances.
  • Instance:
    Oracle defines the term instance as the memory structure and the background processes used to access data from a database.
  • Session:
    A session is a user process in communication with a server process. There will usually be one user process per user and one server process per user process.
  • Paradigm:
    A paradigm is a set of standards, agreed upon by all those involved, that specifies how problems should be understood and addressed.
  • Access to the database:
    Access to the database is through the Oracle instance. The instance is a set of processes and memory structures: it exists on the CPU(s) and in the memory of the server node and this existence is temporary. It is absolutely impossible in the Oracle environment for any user to have direct contact with the database.
Read the full summary
This summary. +380.000 other summaries. A unique study tool. A rehearsal system for this summary. Studycoaching with videos.