Archive log mode
Keep copies of all transactions from the redo logs.
Cold backup
Shuts down the database prior to performing a backup.
Control file
Used to test the database integrity during startup.
Database
Program that manipulates one or more data files.
Data dictionary
Tables and views that are a read-only database reference.
Data warehouse
Repository of data about related objects.
Hot backup
Database is running while performing a backup.
Instance
A set of server processes that has its own
Shared Global Area (SGA), an area of shared memory.
Index
Mini copy of table entries used for rapid access to the data.
Non-arvhive log mode
No save of redo log before it is overwritten.
Redo logs
Keep track of database changes.
System Identifier (SID)
Identifies each database interface.
Table
A database object that holds the data.
Tablespace
A collection of one or more datafiles.
Transaction
Sequence of SQL statements that manipulate the database.
View
A custom presentation of the database table information.
Import and export
Used to perform logical backup and recovery of database objects. Allows extraction of database objects into flat files that can be stored or moved to another database.