Chapter 1 Flashcards
what is an Oracle database?
set of files on disk
How is the database accessed?
The database is accessed through an Oracle instance.
What is an instance?
The instance is a set of processes and memory structures.
- exists in CPU and memory of server
- existence is temporary
- users establish sessions against the instance
- the instance manages all access to the database
What is the Oracle server?
An Oracle server is an Oracle instance with an Oracle database.
What processing model is implemented by the Oracle server?
Client-server processing OR two-tier
What are the components of the client tier?
The two components of the client tier are users and the user processes.
What are the components of the server tier?
The server tier has three components:
- the server processes that execute the SQL
- the instance
- the database
What is a session?
A session is a user process in communication with a server process.
What makes up a session?
There will usually be one user process per user and one server process per user process.
What is the log-on and logoff cycle?
The user and server processes that make up sessions are launched on demand and terminated when no longer required.
What is the database startup and shutdown cycle?
The instance processes and memory structures are launched by the database administrator and persist until the administrator terminates them.
What is a user process?
A user process can be any client-side software that is capable of connecting to an Oracle server process.
- SQL*Plus
- SQL Developer
what is an Oracle database?
set of files on disk
How is the database accessed?
The database is accessed through an Oracle instance.
What is an instance?
The instance is a set of processes and memory structures.
- exists in CPU and memory of server
- existence is temporary
- users establish sessions against the instance
- the instance manages all access to the database
