18.1 DATABASE TERMINOLOGY
- 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.
|
لطفا منتظر باشید ...
